Close/Reopen Excel using Taskkill - possible?

Hi there,

I have the following code that needs to execute. Basically, every once in a while, our terminal program encounters an error that makes it so Excel and it can't talk to each other. The only way to fix this is by killing the entire process tree of both terminal and Excel, or restarting the computer. I've written this bit of code in the event it starts happening while someone is using the macro - it checks to see if the two can talk, and if they can't, it just kills both programs.

Please Login or Register  to view this content.

Obviously, since the last line is:

Please Login or Register  to view this content.

That's the last thing Excel does before it goes and commits suicide, so I can't have any line after that. Is there any way for me, before hand, to like... launch Excel with a 8 second delay, so that once the kill command executes, Excel re-opens? Or could I write a batch file with delay built in to execute prior to the kill command? I could use Shell to execute that prior to killing Excel, but I'm not sure if that's possible....

How about after clicking YES you call up a .bat file that kills the excel.exe task and launch it again? I have an example for you if that is something you are looking at.

That's exactly what went through my head after I posted this... I created a batch file that reads:

Please Login or Register  to view this content.

and that works perfectly - as by the time those 5 seconds are up, the macro has finished running and killing Excel.

The issue is - I don't know how to run it... I found a few things on various forums, but none of them seem to work. Here's my code now:

Please Login or Register  to view this content.

But I just get a blank CMD window opening... I've messed around with a few different things and I can't get that path to go into the CMD window.

Is there a reason why you have to close excel the application? Would it work if you just close the workbook its pertaining to and reopen the workbook?

Originally Posted by Sniper

How about after clicking YES you call up a .bat file that kills the excel.exe task and launch it again? I have an example for you if that is something you are looking at.

This is the code that you must call in excel:

Please Login or Register  to view this content.

Just create the batfile then to kill: pcscm.exe, pcsws.exe, excel.exe and then restart them

Here is example of bat

that makes a lot more sense to do it that way actually............ Thanks man! Good idea.

Originally Posted by lordterrin

that makes a lot more sense to do it that way actually............ Thanks man! Good idea.

Pleasure!!

two questions on this though:

1. What does the /c do?
2. My path name has spaces in it, and I can't change that. When I execute, VBA says "file not found," but I'm sure the file path is correct. How do I work with the spaces inherent in the file path?

Please Login or Register  to view this content.

File Not Found But the file's there