How to Copy | Paste my worksheet into MrExcel.com forum (using Excel 2016)

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: How to Copy | Paste my worksheet into MrExcel.com forum (using Excel 2016)

  1. #1
    Board Regular
    Join Date
    Feb 2011
    Posts
    93
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default How to Copy | Paste my worksheet into MrExcel.com forum (using Excel 2016)

     
    Using Excel 2016, exactly HOW do I copy the information from my worksheet into a proper Excel format in MrExcel.com?

    I have tried and, while it pastes, it does not have the Excel-type format I see in other posts (like borders and stuff).
    Last edited by mark91345; Nov 12th, 2017 at 11:22 PM.

  2. #2
    Board Regular alansidman's Avatar
    Join Date
    Feb 2007
    Location
    Steamboat Springs
    Posts
    4,013
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to Copy | Paste my worksheet into MrExcel.com forum (using Excel 2016)

    Read this MrE announcement. There are several options available to you.

    https://www.mrexcel.com/forum/board-...forum-use.html
    Alan Sidman
    Win 10--Office 2016

    Click below for a white paper on Data Base Design
    http://r937.com/relational.html



  3. #3
    Board Regular
    Join Date
    Feb 2011
    Posts
    93
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to Copy | Paste my worksheet into MrExcel.com forum (using Excel 2016)

    Well, I read it, and downloaded both "MrExcel HTML Maker (updated 2017) (Win), Forum Tools Add-In (updated 2017) ", but when I click on them, it opens Excel 2016, then that's it.

    There's no instructions, nothing.

  4. #4
    Board Regular Scott T's Avatar
    Join Date
    Dec 2016
    Posts
    1,663
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to Copy | Paste my worksheet into MrExcel.com forum (using Excel 2016)

    Put the file in your add ins folder
    Code:
    C:\Users\UserName\AppData\Roaming\Microsoft\AddIns
    
    
    Due to security you should unblock the addin. right click on the file and then properties and select unblock. If you do note have admin rights on the computer you will not see the option to unblock it. If that is the case you can go into options and select trust center. Then trusted locations and add the path as a trusted location.

    In Excel go to options then Add_ins
    Select mange excel Add-ins
    Put a check next to Mrexcelhtmlmaker2017807 and click OK.
    Last edited by Scott T; Nov 13th, 2017 at 12:42 PM.
    Colonel Sandurz: Prepare ship for light speed.
    Dark Helmet: No, no, no, light speed is too slow.
    Colonel Sandurz: Light speed, too slow?
    Dark Helmet: Yes, we're gonna have to go right to ludicrous speed.

  5. #5
    Board Regular
    Join Date
    Feb 2011
    Posts
    93
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to Copy | Paste my worksheet into MrExcel.com forum (using Excel 2016)

    Thank you!

  6. #6
    Board Regular MARK858's Avatar
    Join Date
    Nov 2010
    Location
    Southern England
    Posts
    8,967
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to Copy | Paste my worksheet into MrExcel.com forum (using Excel 2016)

      
    Last edited by MARK858; Nov 18th, 2017 at 01:13 PM.
    Test VBA on a copy of your data (remember you can't normally reverse the action)

    Please follow the forum Rules and Guidelines & please use Code tags around your code i.e. [CODE]your code[/CODE]

    To post a screenshot try one of these links
    MrExcel HTML Maker, Excel jeanie, RoryA addin (Win & Mac) or Borders-Copy-Paste

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com