Saving files automatically

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
 
D

Dave Peterson

application.displayalerts = false
'your code to save
application.displayalerts = true
 
J

Jacob Skaria

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

Lose macros before saving 4
VBA editor doesn't prompt to save changes, doesn't save 3
Routine for checking if file exists 6
Change To Read Only 1
Can you write VBA to export objects 1
save as - location or default 3
Automatically Saving created FILE 1
Insert/Embed PDF File automatically via VBA 1

Top