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
(e-mail address removed)
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Save workbook without shapes 0
Autonumber field in Excel that behaves the same as Access 0
Restoring Overwritten Files 2
Replace in a group or selection or collection of word files 1
Can't save my Office documents (after computer rebuild and reauthorization) 0
Descenders clipped 0
My Visio2019 Keep Crashed when open the program 0
Prompt For Replace in Selection And More... 0

Top