suppressing auto-dailog boxes
 

I have a macro which creates and saves an excel file with a particular name.
If the macro is run again Excel will ask if I want to overwrite the file.

Is there any way to suppress the dialog so the file is saved anyway? (If I
try to delete the file first, Excel asks whether I want to to delete it - so
effectively same problem!).

I have several similar situations where I do not want the user to need to
intervene, but don't know a way to suppress such dialog boxes.

suppressing auto-dailog boxes
 

Precede the save with
Application.DisplayAlerts = False

"Chas" wrote in message
...
I have a macro which creates and saves an excel file with a particular
name.
If the macro is run again Excel will ask if I want to overwrite the file.

Is there any way to suppress the dialog so the file is saved anyway? (If I
try to delete the file first, Excel asks whether I want to to delete it -
so
effectively same problem!).

I have several similar situations where I do not want the user to need to
intervene, but don't know a way to suppress such dialog boxes.