SaveAs
 

I want VBA to save a file using SaveAs and have it replace an existing file. How do I make it not display the dialog box telling me that the file already exists and asking if I want to replace it

SaveAs
 

Bill

Application.DisplayAlerts = False
' your code
Application.DisplayAlerts = True

Regards

Trevor


"Bill" wrote in message
...
I want VBA to save a file using SaveAs and have it replace an existing
file. How do I make it not display the dialog box telling me that the file
already exists and asking if I want to replace it?