Closing VB triggers closing Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
Back
Top