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, _
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.