suppressing auto-dailog boxes

[Guest]

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.

 

[Bob Umlas]

Precede the save with
Application.DisplayAlerts = False