Results 1 to 10 of 10

Thread: How to post spreadsheet in forum
Thanks Thanks: 0 Likes Likes: 0

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

    Default How to post spreadsheet in forum

    I have tried installing the various .xla file in order to copy/paste my Excel worksheets; however, I keep getting errors, mainly saying that they are incompatible with my version of Excel (version 365).

    Does Excel have its own feature to do this, or is there a nice, modern program that can help?
    Yes, I looked at the https://www.mrexcel.com/forum/board-...-vba-code.html
    but either the files don't work, or there's no instruction (or the instruction is out-of-date).

    Help!

  2. #2
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    28,379
    Post Thanks / Like
    Mentioned
    471 Post(s)
    Tagged
    47 Thread(s)

    Default Re: How to post spreadsheet in forum

    The add-ins for posting a portion of your data, rather than code, can be found here https://www.mrexcel.com/forum/about-...tachments.html
    Last edited by Fluff; Aug 15th, 2019 at 02:23 PM.
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

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

    Default Re: How to post spreadsheet in forum

    Ok. I downloaded MrExcel HTML maker.
    In Excel, I hit ALT-T, I

    Then, browsed for the add in, added the checkbox (then OK)

    Once I leave Excel, and open Excel again, the tab for MrExcel HTML maker (on top) disappears. I don't know how to make it reappear.
    Last edited by mark91345; Aug 15th, 2019 at 02:30 PM.

  4. #4
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    28,379
    Post Thanks / Like
    Mentioned
    471 Post(s)
    Tagged
    47 Thread(s)

    Default Re: How to post spreadsheet in forum

    I'm using Office 365 & the "MrExcel HTML Maker" available from post#2 in that link, without any problems
    Are you sure you're not downloading the VBHTMLMaker instead?
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

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

    Default Re: How to post spreadsheet in forum

    https://onedrive.live.com/?id=8CFFDE...FFDEC0CE27E813

    The file I downloaded is MrExcel HTML Maker 20170807.zip


    Does it matter that my Excel is 64-bit?
    Last edited by mark91345; Aug 15th, 2019 at 02:37 PM.

  6. #6
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    28,379
    Post Thanks / Like
    Mentioned
    471 Post(s)
    Tagged
    47 Thread(s)

    Default Re: How to post spreadsheet in forum

    That's the correct file and as far as I'm aware it should work with 64bit versions of office.

    Just noticed you've edited post#3, did you unblock the file?
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

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

    Default Re: How to post spreadsheet in forum

    I'm not sure what "unblock" means. However, I found a YouTube video which indicated I needed to add the "file path" in Excel's "Trust Center's" Trusted Locations section. I did and now the HTML Maker shows up after I exit and re-open Excel. YAY!!!!

    Thank you for responding so quickly to my posts.

  8. #8
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    28,379
    Post Thanks / Like
    Mentioned
    471 Post(s)
    Tagged
    47 Thread(s)

    Default Re: How to post spreadsheet in forum

    Glad you got it sorted & thanks for the feedback.
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  9. #9
    MrExcel MVP
    Moderator
    Peter_SSs's Avatar
    Join Date
    May 2005
    Location
    Macksville, Australia
    Posts
    41,005
    Post Thanks / Like
    Mentioned
    90 Post(s)
    Tagged
    21 Thread(s)

    Default Re: How to post spreadsheet in forum

    Quote Originally Posted by mark91345 View Post
    I'm not sure what "unblock" means.
    I see you now have it working, but for the record, read the N.B. section at the bottom of post 2 in the link Fluff provided in post 2 in this thread.
    Hope this helps, good luck.
    Peter
    Excel 365 - Windows 10
    - Want to help your helpers by posting a small, copyable, screen shot directly in your post? Look here
    - If posting vba code, please use Code Tags - like this [code]Paste code here[/code] - or use the # key in the Reply window
    - Read: Forum Rules, Forum Use Guidelines, & FAQ

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

    Default Re: How to post spreadsheet in forum

    Thanks Peter. I found the "unblock" box (it was UNchecked).

Some videos you may like

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
  •