View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK[_3_] NickHK[_3_] is offline
external usenet poster
 
Posts: 415
Default 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