I have some code that saves a file with a set name and
path using the ActiveWorkbook.SaveAs method. When the file
already exists, the user is prompted about whether to
write over the file. If the user answers 'No' or 'Cancel',
an error (#1004) occurs. My error handler hasn't been able
to trap this error for some reason. Is there a quick way
to get Excel to prompt for another file name and then
continue processing the remaining code? Thanks.

Hi

You could use

Application.DisplayAlerts = False

ActiveWorkbook.SaveAs ("Test saveas.xls")

Application.DisplayAlerts = True

which will force an overwrite. If you don't want to do that for fear of
overwriting a different existing file, you could use

Excel.Application.Dialogs(xlDialogSaveAs).Show

where you can change the saveas name or cancel without the error.



HTH



KenM