MrExcel HTML Maker Update

[MrKowz]

Thanks, Mark. I noticed the hex numbers within the cell HTML as well, but since it wasn't have any negative effect on the posts, so I didn't adjust. I think today I'll go through and clear em all out with the equivalent RGB color to further future-proof the addin.

 

[Peter_SSs]

Just for the record, I'm getting the "2 square" problem (as mentioned in the threads below) fairly regularly when using the new MrE HTML Maker. I have had the same problem with Excel jeanie in the past but it (jeanie) seems more reliable in that regard recently.

https://www.mrexcel.com/forum/about-board/936686-bbcode-range-add-not-working.html
Mr Excel HTML Maker

 

[MrKowz]

Just for the record, I'm getting the "2 square" problem (as mentioned in the threads below) fairly regularly when using the new MrE HTML Maker. I have had the same problem with Excel jeanie in the past but it (jeanie) seems more reliable in that regard recently.

bbcode range add-in not working
Mr Excel HTML Maker

Finally had a chance to really look into those posts - very strange. Are you able to replicate the issue with any level of consistency, or is it very hit or miss?

 

[Peter_SSs]

Are you able to replicate the issue with any level of consistency, or is it very hit or miss?

Sorry, no consistency and nothing I've picked up that might be triggering it.

 

[MrKowz]

Thanks, Peter. And just to be sure.... I know you've referenced my AddIn as the "MrE HTML Maker". Please note that the Forum Tools uses the "MrE" prefix. My tool uses the "MrExcel" prefix.

I know it's confusing.... didn't know the Forum Tools addin used that prefix prior to making my adjustment.

 

[RoryA]

FYI I've updated the HTML code in forum tools to use rgb instead of hex. I also plan to streamline the code base at some point so that both versions produce the same output just with different tags.

Re the clipboard issue, it seems to occur with Win8 and later if you have an Explorer window open. Using API is better.

 

[Peter_SSs]

FYI I've updated the HTML code in forum tools to use rgb instead of hex.

Rory, can you confirm where to get the updated version? Following the link in your signature and downloading from part-way down the Excel Matters page I get a file called Forum Tools - old.xlam which doesn't sound reassuring.

Re the clipboard issue, it seems to occur with Win8 and later if you have an Explorer window open.

Thanks for that info, I'll see if that holds true for me.

 

[RoryA]

Oh! Thanks, Peter - I'll update the link on my site and get back to you!

Edit: OK link should be fixed now.

 

[Peter_SSs]

OK link should be fixed now.

Thanks Rory, I'll give it a try.

 

[Scott T]

When I close Excel add-in tab on the ribbon does not appear and the Excel MrExcel HTML options on the right click menu do not appear after opening Excel again. I have to uncheck the add-in close the add-in manager go back in and check it. I am running office 365 build 8431.2094. Any idea what is happening?

Also it does not put in the full grid could the option be put in so that it will create a table with the full grid lines.

Thanks

EDIT: I appear to have solved it not showing up by clicking the unblock in the file properties.