macro for closing all Excel processes visible in TaskManager

[mechif]

Hi!
My VBScript is quite hefty and takes 1 hour+ to run. I found that if
other Excel processes exist, it further impedes it. Sometimes, by
mistake (if the script stops in the middle, etc.), Excel processes are
not closed completely.

I start the script by telling the user to close all Excel
applications. I'd like to ensure that no applications and/or
processes are present before i start the script.

Is there any way to do this?
Mechi

 

[Norman Jones]

Hi Mechi,

Permit me to respond to the first
paragraph of your post:

=============
My VBScript is quite hefty and takes 1 hour+ to run. I found that if
other Excel processes exist, it further impedes it. Sometimes, by
mistake (if the script stops in the middle, etc.), Excel processes are
not closed completely
=============

With the appropriate use of error handles,
this situation should not normally occur;
the error handler should ensure a graceful
exit and may set the relevant object varables
to nothing.

I think that the second paragraph of your
post might, perhaps, more appropriately be
posted to one of the Windows newsgroups.