Save Individual Worksheet as HTML file

[mcelligott]

Hello all,

Through VBA I would like to save only one sheet from an Excel workbook as a single file web page. I can save the entire workbook but haven't figured out how to save only the one sheet.

Any help would be greatly appreciated.

Thanks,

Bob

 

[fumei]

Have you tried recording this as a macro, then adjusting? It is fairly easy.

expression.Add(SourceType, FileName, Sheet, Source, HtmlType, DivID, Title)

Sheet is a parameter. So you can declare any sheet of a workbook to be saved as HTML.

Gerry