HTML Output

[sats43]

Hi,

I have excel table, i need to export that data into HTML format, is it possible, if so can you please let me know how to do and it would be great if its possible with VBA

Thanks

[Leith Ross]

Hello sats43,

The macro is set to create an HTML file from the Active Sheet range "A1:C10" and save it to the file "HTML Test File" in the directory "C:\". You can change these to what you want. The are marked in bold in the code. If FilePath is set to an empty string (""), you will be prompted to select a new location. The default file extension is ".htm"

Please Login or Register  to view this content.

[sats43]

Hello Ross,

The code is not giving any error, but its also not giving any result, i think its doing some calculations but .. no result, could you please check again thanks ..