Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving files automatically
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving files automatically
application.displayalerts = false
'your code to save application.displayalerts = true Richard Burton wrote: 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 -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving files automatically
Application.DisplayAlerts = False
Activeworkbook.SaveAs filename Application.DisplayAlerts = True -- Jacob "Richard Burton" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically saving a file | Excel Programming | |||
Automatically saving changes | Excel Discussion (Misc queries) | |||
Automatically saving changes | Excel Discussion (Misc queries) | |||
Closing files and saving files | Excel Worksheet Functions | |||
FILES CREATED AUTOMATICALLY WHILE SAVING | Excel Discussion (Misc queries) |