"Go ahead and replace file" command?

[Ed]

I need to create a file and SaveAs a file with the same name. Will the
Alerts = False automatically tell it "Yes, replace the other file with the
same name"? Or is there another line I should add to the SaveAs code to
tell Excel to overwrite and replace the existing file?

Thanks.
Ed

 

[Tom Ogilvy]

Yes,
Application.DisplayAlerts = False

will allow you to overwrite the file without prompt.

Another approach is to Kill any existing file before doing the saveas

fName = "C:\Myfolder\Myfile.xls"
On Error Resume Next
Kill fName
On Error goto 0
Thisworkbook.SaveAs fName

 

[Ed]

Thanks, Tom. I appreciate the help.

Ed

Yes,
Application.DisplayAlerts = False

will allow you to overwrite the file without prompt.

Another approach is to Kill any existing file before doing the saveas

fName = "C:\Myfolder\Myfile.xls"
On Error Resume Next
Kill fName
On Error goto 0
Thisworkbook.SaveAs fName