Running processes with VBA

Question

Hi,

Using http://support.microsoft.com/kb/129796 to kick-off a process in VBA.

The VBA code successfully waits for the process to exit before continuing, but the process isn't killed when Excel is abruptly terminated. Is there a way to create a process like that?

Thanks.

Answer 1

Hi,

Not wishing to be vague, the answer to that would depend on the spawned process but in general I doubt very much if you will be able to achieve what you want but look forward to someone coming up with a solution.

---

If this post answers your question, please mark it as the Answer.

Mike H

Answer 2

Sure, I understand that it's too late for Excel to act. But is there a way to make the spawned process be dependent on the parent process being alive?

thanks

Answer 3

Hi,

I think if the Excel process is killed in that way then it can have no influence over the process you called with shell.

---

If this post answers your question, please mark it as the Answer.

Mike H

Answer 4

hi Mike,

Thanks for your reply.

I mean if the Excel process is killed by Task Manager for example.

Cheers,

Antranik

Answer 5

hi,

What do you mean by 'abruply terminated'?

---

If this post answers your question, please mark it as the Answer.

Mike H