Hi,

I have a multiple sheet excel workbook want to save one sheet as a html file using VBA.

It should be like save as operation when do manual save as the format in the excel is displaying in the saved HTML file but when try to do this using VBA or macro the file is got saved but format got lost.

Thanks,