macro for closing all Excel processes visible in TaskManager
 

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

macro for closing all Excel processes visible in TaskManager
 

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.


---
Regards.
Norman

wrote in message
...
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