Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Override save as Dialog box
I have a macro that creates a files called member.xls and sticks it on my
desktop. When it saves the file, a dialog box appears and asks me if I want to replace the file that already exists. How do I keep this dialog box from coming up since I always want to replace the file on the desktop for the newer version that I just created? Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Override save as Dialog box
application.displayalerts=false
'your code to save application.displayalerts = true Raza wrote: I have a macro that creates a files called member.xls and sticks it on my desktop. When it saves the file, a dialog box appears and asks me if I want to replace the file that already exists. How do I keep this dialog box from coming up since I always want to replace the file on the desktop for the newer version that I just created? Thanks. -- Dave Peterson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Override save as Dialog box
Thanks, that worked great!
"Dave Peterson" wrote: application.displayalerts=false 'your code to save application.displayalerts = true Raza wrote: I have a macro that creates a files called member.xls and sticks it on my desktop. When it saves the file, a dialog box appears and asks me if I want to replace the file that already exists. How do I keep this dialog box from coming up since I always want to replace the file on the desktop for the newer version that I just created? Thanks. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Default Cell Values & Save Changes Dialog Box | Excel Discussion (Misc queries) | |||
Save as Dialog Box Mysterious " " | Excel Worksheet Functions | |||
How do you disable save file dialog? | Setting up and Configuration of Excel | |||
Save a Copy/Overwrite changes dialog box | Excel Discussion (Misc queries) | |||
Save a Copy/Overwrite changes dialog box | Excel Worksheet Functions |