Automation problem saving Excel as HTML.
 

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

Automation problem saving Excel as HTML.
 

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


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=507144