Automatically accepting overwrite

R

robert_woodie

ok so i have this code:

ActiveWorkbook.SaveAs Filename:="FILENAME.xls", _
FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False

but when it runs it asks me if i want to overwrite the existing
file.which i do

How can i alter this code to automatically overwrite?

Thanks
Robert
 
P

Philip Reece-Heal

Robert

This line of code may well work:
Application.DisplayAlerts=False

Regards

Philip
 
Top