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
|