Hi,

i have an excel workbook open and i need to create a macro that will save the workbook as an html file, but leave the original file the same.

i know there is a SaveCopyAs function, but i can only get that to work with saving as an .xls file.

Does anyone know if the SaveCopyAs has the ability to save the current workbook as an HTML file without changing what's in memory?

thanks
Scott

Hi Scott

SaveCopyAs doesn;t have the option to save the workbook as HTML

You can try writing a small macro, which will open the Saved copy of Workbook and convert it as HTML in a new Excel instance (without affecting the existing one)

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)