Automation problem saving Excel as HTML.

[nicol]

Hi,

I'm trying to save an excel file as html using workbook.SaveAs(fileName,
Excel.XlFileFormat.xlHtml). I'm using a randomly generated filename, which
are being reused eventually leaving me in a situation where I'm attempting to
overwrite a file which alreay exists. I get the error message described in KB
article KB221084

"Alert: The folder that this Web page would use to organize supporting files
is already reserved for use in the current location... "

What I need to know is are there specific files I can delete before
attempting the save to workaround this problem or is there another solution
(aside from choosing a different filename).

Thanks

 

[tony h]

you need to delete the file filename.htm and the folder filename_files