How to put excel into batch mode

[Lew Schwartz]

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

 

[NickHK]

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]

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

 

[Lew Schwartz]

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

 

[Guest]

Lew,

As you probably have come to realize...Excel is designed to execute with
user interaction. That means there are other environment factors such as
registry settings, directory structures, and permissions that need to exist
for Excel to execute in an automated manner.

I have written two blog posts that you should find useful:

In this post just ignore the grid computing and Digipede references. The
problems I provide solutions for will likely be relevant to your problem
space.
http://krgreenlee.blogspot.com/2006/03/digipede-distributing-excel_10.html

In this post I provide what I call an Excel Controller written in Visual
Basic Script. Using an Excel Controller makes it easier to control the
disabling of Excel's GUI settings as well as providing finer control over
shutdown and cleanup. An Excel Controller can be written in any language
that can access Excel's COM API.
http://krgreenlee.blogspot.com/2006/04/excel-running-excel-on-windows-task.html

Besides the pain of trial-and-error, I used this Microsoft document as a
starting pointer for figuring out how to successfully run Excel on a compute
grid.
http://support.microsoft.com/default.aspx/kb/257757/

Good luck

Kim Greenlee