avoiding dialog boxes in macros
Application.DisplayAlerts = False
' Your code here to overwrite file.
Application.DisplayAlerts = True
HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------
I have a script that I'm working on that, among other things may try and
write a file that already exist. Currently, it pops up a dialog box and
stalls the process. I'd like to not have the dialog boxes come up, but
rather simply overwrite the file. What option(s) do I need to specify to
accomplish that goal?
Bruce
|