Macro for creating basic HTML table? (from selected data)

[Matt Rhoades]

Does anyone know of a macro or code to create a simple HTML table from the data you select?
I know of an old one called excel to web, but it does not work with excel 2007.

Thanks!
matt_Rhoades@mosaictec.com

 

[Hermanito]

I wrote one for my own use... it recognises the following things:
- background color
- horizontal text alignment
- merged cells (vertical and horizontal)
- bold, italic, underlined

It only generates the text with the table tags included, not a complete html document, and outputs this to the Immediate window, nothing fancy, but it works fine for what I need...
If you have enough with these features, let me know, I'll post the code...

 

[Matt Rhoades]

thats more than enough i think.

I really just want to get the table with the padded grid lines so I can steal it and spruce it up elsewhere!

Thanks, can I get that code?

 

[Matt Rhoades]

http://tableizer.journalistopia.com/

Essentially I want this to happen, but with a MACRO of some sort!

Thanks all

 

[Trevor G]

If you select to record a macro and then use the office button you can look at the option to use save as other formats and then select the html from there. the code will look like this:

ActiveWorkbook.SaveAs Filename:="C:\Users\Trevor G\Documents\test.htm" _
, FileFormat:=xlHtml, ReadOnlyRecommended:=False, CreateBackup:=False

You will have a little extra to do, like changing activeworkbook to activesheet

 

[Hermanito]

Okay.... here it is... you will need to put all this code in a module. Also, make sure that the workbook you put this in, has a reference to the Microsoft Forms 2.0 Object Library. This is needed for the functionality to put the generated table in the clipboard.
Usage: select a rectangular range, run macro, choose ConvertSelection, paste result wherever you need it...

PM me an email-address and I will send the workbook to you...