Saving files automatically

  • Thread starter Thread starter Richard Burton
  • Start date Start date
R

Richard Burton

Hi,

I have a macro to save a number of different versions of my file for
different budget holders. When this is run, it recognises that the file
already exists and prompts to allow it to be overwritten. Is there some VBA I
can add to accept the prompt automatically?

Thanks

Richard
 
application.displayalerts = false
'your code to save
application.displayalerts = true
 
Application.DisplayAlerts = False
Activeworkbook.SaveAs filename
Application.DisplayAlerts = True
 

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

Overriding the overwrite confirmation prompt 2
Change To Read Only 1
VBA editor doesn't prompt to save changes, doesn't save 3
Replace file without being prompted to save 2
Lose macros before saving 4
Saving a File to a Name That Already Exists 1
Automatically opening file saved to someone "Documents&Sett' direc 1
OT: IE Save Dialog gone! 10

Back
Top