Save workbook as HTML

**scabral** · 07-28-2009, 02:36 PM

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

**SDruley** · 07-28-2009, 03:27 PM

Try this:

ActiveWorkbook.SaveAs Filename:= _
"C:\Users\Scott\Documents\Book2.htm", FileFormat:=xlHtml, _ ReadOnlyRecommended:=False,CreateBackup:=False

**scabral** · 07-28-2009, 03:53 PM

that does save the file correctly, however, it updates the excel file that is open to that file name. I don't want the current file name to change, just to be saved as html somewhere else.

**martindwilson** · 07-28-2009, 04:35 PM

saving "as" doesnt change the file, you will still have the original and a new one as .htm
(the htm is in the window
the xl one has just closed without saving)
if you reopen excel file it will be in its last saved state (before you saved as htm)