SaveAs

B

Bill

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?
 
D

Don Guillett

application.displayalerts=false

--
Don Guillett
SalesAid Software
[email protected]
Bill said:
I want VBA to save a file using SaveAs and have it replace an existing
Click to expand...
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?
 
G

Gord Dibben

Bill

Application.DisplayAlerts = False
'your save as code goes here
Application.DisplayAlerts = True

Gord Dibben Excel MVP
 
Top