Automatically accepting overwrite

[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

 

[Philip Reece-Heal]

Robert

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

Regards

Philip

 

[robert_woodie]

yep it does
thanks for your hel