I need some VBA code that will take a selected range in MS Excel and will convert that range into an HTML table. I can't simply copy and paste the table because I want to get rid of all of the CSS that MS includes when you simply copy and paste a table.
So the code should convert the selection into an HTML table and dump that HTML to a text file or something.
There is a special requirement that the code needs to correctly color any cells that might have conditional formatting. The conditional formatting of the cells is very important.
The code must work on a selection range.
The resulting HTML table should be free of any other CSS or style tags, except for the cell color.
Feel free to let me know if you have any questions. I will pay $50 for this code.
I have attached a sample sheet that has a table to be converted.