Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
avoiding dialog boxes in macros
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 -- +-------------------+---------------------------------------------------+ Bruce Bowler | When your illusions are gone you have ceased to 1.207.633.9600 | live. - Anonymous | +-------------------+---------------------------------------------------+ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
avoiding dialog boxes in macros
if it is a workbook
Application.DisplayAlerts = False thisworkbook.SaveAs . . . Application.DisplayAlerts = True An alternative is fName = "C:\Whatever.xls" On error resume next kill fname On Error goto 0 Thisworkbooks.SaveAs fName -- Regards, Tom Ogilvy "Bruce Bowler" wrote in message ... 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 -- +-------------------+---------------------------------------------------+ Bruce Bowler | When your illusions are gone you have ceased to 1.207.633.9600 | live. - Anonymous | +-------------------+---------------------------------------------------+ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dialog Boxes | Excel Discussion (Misc queries) | |||
Dialog Boxes | Excel Discussion (Misc queries) | |||
Dialog boxes | Excel Discussion (Misc queries) | |||
avoiding Load/Save Dialog | Charts and Charting in Excel | |||
Suppress the Disable Macros / Enable Macros Dialog | Excel Programming |