Hi!

I need help for somethig I guess is very simple:

I have a file that needs to be replaced with the same name. I'm saving it with the following code:

ActiveWorkbook.SaveAs Filename:="\GA\temp\AR.xls", FileFormat:=xlNormal, _
Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
CreateBackup:=False

But there is a file in that location with the same name, which is the one that I need to replace. And it wil always be like that.

I need to know how to get rid of the warning that asks me if I want to rplace the existing file or not.

Thank you!

Can't you delete the file first then write it again with the same file name?