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.
|