Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How many excel processes can you open? | Excel Programming | |||
VBAProject still visible after closing workbook | Excel Programming | |||
Worksheet has to set to visible as it is not visible after saving and closing Excel by VB. | Excel Programming | |||
Schedule taskmanager via code? | Excel Programming | |||
Multiple Excel Processes | Excel Programming |