How to put excel into batch mode
in [Programming]
|
From: Lew Schwartz on 9 Oct 2006 10:09 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
From: NickHK on 9 Oct 2006 10:22 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" <lschwartz(a)sionline.com> ???g??l??s?D:%23Sq4Nw66GHA.2288(a)TK2MSFTNGP05.phx.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 >
From: Lew Schwartz on 9 Oct 2006 10:56 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" <k24(a)hotmail.com> wrote in message news:%232MKM566GHA.3760(a)TK2MSFTNGP02.phx.gbl... > 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" <lschwartz(a)sionline.com> > ???g??l??s?D:%23Sq4Nw66GHA.2288(a)TK2MSFTNGP05.phx.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 >> > >
From: Lew Schwartz on 9 Oct 2006 15:39 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
|
Pages: 1 Prev: Select a range within a range Next: SecSvr32 Operation exception |