Closing VB triggers closing Excel

[Guest]

Hi, I wanted to ask a question about linking closing a Visual Basic
application with closing Excel. I have a VB app that calls an Excel macro.
If for some reason someone closes the VB app (normally, by ctrl+alt+del'ng,
or just in any way at all), I want Excel to automatically close also. Is it
possible to do this ? Thanks.

 

[NickHK]

Minilek,
How are you opening Excel initially ?

NickHK

 

[Jeff Standen]

It's been a while since I used VB, but I think you can have a form_unload
event in your code - you can put the excel closing stuff in there. Not sure
if this would work with ctrl-alt-del. Plus, if the macro is running in
Excel, this may cause other problems. I'm not being much help here - I don't
have VB installed

Cheers,

Jeff