Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Closing VB triggers closing Excel
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Closing VB triggers closing Excel
Minilek,
How are you opening Excel initially ? NickHK "Minilek" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Closing VB triggers closing Excel
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 "Minilek" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Closing workbooks w/o closing Excel | Excel Discussion (Misc queries) | |||
Closing Excel | Excel Discussion (Misc queries) | |||
HOW WE CLOSING MS.EXCEL. | Excel Discussion (Misc queries) | |||
closing Excel in VBA | Excel Programming | |||
closing excel after closing a workbook | Excel Programming |