How to post spreadsheet in forum

[mark91345]

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-announcements/515787-how-post-your-vba-code.html
but either the files don't work, or there's no instruction (or the instruction is out-of-date).

Help!

 

[Fluff]

The add-ins for posting a portion of your data, rather than code, can be found here https://www.mrexcel.com/forum/about-board/508133-attachments.html

 

[mark91345]

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.

 

[Fluff]

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?

 

[mark91345]

https://onedrive.live.com/?id=8CFFDEC0CE27E813!189&cid=8CFFDEC0CE27E813

The file I downloaded is MrExcel HTML Maker 20170807.zip


Does it matter that my Excel is 64-bit?

 

[Fluff]

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?

 

[mark91345]

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.

 

[Fluff]

Glad you got it sorted & thanks for the feedback.

 

[Peter_SSs]

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.

 

[mark91345]

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