Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to put excel into batch mode
This is an addition to my other questions. In order for me to automate my
processes, it's important for excel not to do anything that might put it into a wait state. So far I've dealt with the following: AutomationSecurity on high (3) to disable macros DisplayAlerts to false Prevents modal dialogs (does excel have non-modal dialogs?) AskToUpdateLinks = false Don't query to pull in data from the internet. Is there anything else that should be on this list? -Lew |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to put excel into batch mode
Lew,
Depending what you are trying to achieve, there's also : Application.IgnoreRemoteRequests Application.Interactive They have repercussions, so check the help first. And use plenty of error trapping I would guess. NickHK "Lew Schwartz" .gbl... This is an addition to my other questions. In order for me to automate my processes, it's important for excel not to do anything that might put it into a wait state. So far I've dealt with the following: AutomationSecurity on high (3) to disable macros DisplayAlerts to false Prevents modal dialogs (does excel have non-modal dialogs?) AskToUpdateLinks = false Don't query to pull in data from the internet. Is there anything else that should be on this list? -Lew |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to put excel into batch mode
Thanks, Nick:
I hope that about does it. Would you know if there's any similar stuff that might come into play on the wb or ss level, even if AutomationSecurity is high and DisplayAlerts is off? TIA -Lew "NickHK" wrote in message ... Lew, Depending what you are trying to achieve, there's also : Application.IgnoreRemoteRequests Application.Interactive They have repercussions, so check the help first. And use plenty of error trapping I would guess. NickHK "Lew Schwartz" .gbl... This is an addition to my other questions. In order for me to automate my processes, it's important for excel not to do anything that might put it into a wait state. So far I've dealt with the following: AutomationSecurity on high (3) to disable macros DisplayAlerts to false Prevents modal dialogs (does excel have non-modal dialogs?) AskToUpdateLinks = false Don't query to pull in data from the internet. Is there anything else that should be on this list? -Lew |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to put excel into batch mode
Does AutomationSecurity = high supersede EnableEvents? ie if excel has a ss
open with event code that fires when I change wb and/or ss, will my AutomationSecurity = 3 prevent the event code or must I (dis)EnableEvents as well? -Lew |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide Excel session when running at the batch mode | Excel Discussion (Misc queries) | |||
creating Excell with Digital Certificate - Batch Mode | Excel Programming | |||
How to refresh a Excel workbook with pivot & ADO query report in batch mode | Excel Discussion (Misc queries) | |||
How to refresh a Excel workbook with pivot & ADO query report in batch mode | Excel Programming | |||
Excel in batch mode | Excel Programming |