Save workbook as HTML

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