SaveAs macro: How do I specify "Replace existing file?"
 

Hello,

I have an excel macro that saves under a specific name everyday. I DO
want to replace that file when I save it.

How do I tell the SaveAs to overwrite the previous file?

Here's my code.

ActiveWorkbook.SaveAs Filename:= _
"C:\file.xls", FileFormat:= _
xlNormal, Password:="", WriteResPassword:="",
ReadOnlyRecommended:=False _
, CreateBackup:=False

I have to use SaveAs and not Save because my macro Copies/Pastes as
value before saving under another name.

Thanks

SaveAs macro: How do I specify "Replace existing file?"
 

Application.DisplayAlerts = False
ActiveWorkbook.SaveAs Filename:= _
"C:\file.xls", FileFormat:= _
xlNormal, Password:="", WriteResPassword:="",
ReadOnlyRecommended:=False _
, CreateBackup:=False
Application.DisplayAlerts = True

--
Regards,
Tom Ogilvy


wrote in message
oups.com...
Hello,

I have an excel macro that saves under a specific name everyday. I DO
want to replace that file when I save it.

How do I tell the SaveAs to overwrite the previous file?

Here's my code.

ActiveWorkbook.SaveAs Filename:= _
"C:\file.xls", FileFormat:= _
xlNormal, Password:="", WriteResPassword:="",
ReadOnlyRecommended:=False _
, CreateBackup:=False

I have to use SaveAs and not Save because my macro Copies/Pastes as
value before saving under another name.

Thanks