Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoSave
i have a program which automatically saves a spreadsheet to the server in the
correct file (ie. estimate\Quotes\EST18000\EST18500\....) if the name already exists, the Excel VBA poses the msgbox if i would like to save over it or not. if the user clicks 'yes', the program is fine and saves over the existing, but if the user clicks 'no' or 'cancel', the program crashes. i'd like it if a 'no' or 'cancel' selection simply tells the program to EXIT rather then get a 'END" or 'DEBUG' msgbox. what is the command to do so? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoSave
try
application.displayalerts=false code application.displayalerts=true -- Don Guillett SalesAid Software "lawson" wrote in message ... i have a program which automatically saves a spreadsheet to the server in the correct file (ie. estimate\Quotes\EST18000\EST18500\....) if the name already exists, the Excel VBA poses the msgbox if i would like to save over it or not. if the user clicks 'yes', the program is fine and saves over the existing, but if the user clicks 'no' or 'cancel', the program crashes. i'd like it if a 'no' or 'cancel' selection simply tells the program to EXIT rather then get a 'END" or 'DEBUG' msgbox. what is the command to do so? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AutoSave | Excel Discussion (Misc queries) | |||
Autosave | Excel Discussion (Misc queries) | |||
Opened Autosave but when closing workbook Autosave closes itself | Excel Worksheet Functions | |||
Removing AUTOSAVE.XLS(AUTOSAVE.XLA) from VBA editor??? | Excel Programming | |||
Removing AUTOSAVE.XLS(AUTOSAVE.XLA) from VBA editor??? | Excel Programming |