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

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

--
Regards,
Tom Ogilvy


<[email protected]> wrote in message
news:[email protected]...
> 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
>