Override existing file without prompting

[catlair]

Hi,

Wish to override an existing file when I run this macro without being
prompted to confirm the override.

Workbooks.Add

ActiveWorkbook.SaveAs Filename:= _
"Macintosh:Users:homeocuments:countries.xls",
FileFormat:=xlNormal, _
Password:="", WriteResPassword:="", ReadOnlyRecommended:=False,
_
CreateBackup:=False

If XX.Name <> ThisWorkbook.Name Then XX.Save ==> THIS DOES NOT
WORK. AM TRYING TO OPEN A NEW FILE AND SAVE IT UNDER A NAME THAT
ALREADY EXIST. ONLY ISSUE IS THAT I HAVE TO CONFIRM IF I WISH TO
OVERRIDE THE EXISTING FILE NAME. IS THERE A WAY TO OVERRIDE THE
EXISTING FILE NAME WITHOUT HAVING TO CONFIRM THE REQUEST?

catlair

 

[Ken Johnson]

Hi catlair,

Does it work if you include...

Application.DisplayAlerts = False

in the code?

Ken Johnson

 

[catlair]

That works! Thanks!