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?

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?