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
|