Saving over an existing file (updating an HTM file)
 

I want to save my workbook as an HTM file after updating. When I do this I
get the warning that the file already exists. How I get around this? I want
the file to save without the warning. Here is the code I'm using to save the
file.

ActiveWorkbook.SaveAs Filename:="C:\XLIMP\MB.htm", FileFormat:=xlHtml, _
ReadOnlyRecommended:=False, CreateBackup:=False

TIA

Steve H

Saving over an existing file (updating an HTM file)
 

add the line
Application.DisplayAlerts = False
immediately before the Save line, and again setting it to
True afterwards

Patrick Molloy
Micosoft Excel MVP
-----Original Message-----
I want to save my workbook as an HTM file after
updating. When I do this I
get the warning that the file already exists. How I get
around this? I want
the file to save without the warning. Here is the code
I'm using to save the
file.

ActiveWorkbook.SaveAs Filename:="C:\XLIMP\MB.htm",
FileFormat:=xlHtml, _
ReadOnlyRecommended:=False, CreateBackup:=False

TIA

Steve H


.

Saving over an existing file (updating an HTM file)
 

Thanks, Patrick. That was just what I needed.

Steve

"Patrick Molloy" wrote in message
...

add the line
Application.DisplayAlerts = False
immediately before the Save line, and again setting it to
True afterwards

Patrick Molloy
Micosoft Excel MVP
-----Original Message-----
I want to save my workbook as an HTM file after
updating. When I do this I
get the warning that the file already exists. How I get
around this? I want
the file to save without the warning. Here is the code
I'm using to save the
file.

ActiveWorkbook.SaveAs Filename:="C:\XLIMP\MB.htm",
FileFormat:=xlHtml, _
ReadOnlyRecommended:=False, CreateBackup:=False

TIA

Steve H


.