Overriding the overwrite confirmation prompt

[Bob]

Is there a way to modify the line below so that if the file "Project
Status.txt" already exists, it will automatically be overwritten without
prompting the user to confirm the overwrite?

ActiveWorkbook.SaveAs Filename:="Project Status.txt", _
FileFormat:=xlText, CreateBackup:=False

Thanks in advance for any help.

Bob

 

[Dave Peterson]

application.displayalerts = false
activeworkbook.saveas ....
application.displayalerts = true

 

[Bob]

Dave,
Thanks a million!
Bob

application.displayalerts = false
activeworkbook.saveas ....
application.displayalerts = true