Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 13
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 49
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Closing workbooks w/o closing Excel Barb in MD Excel Discussion (Misc queries) 3 February 15th 10 06:42 PM
Closing Excel chip1in Excel Discussion (Misc queries) 2 August 31st 09 04:49 PM
HOW WE CLOSING MS.EXCEL. gul Excel Discussion (Misc queries) 1 November 24th 08 05:23 PM
closing Excel in VBA Jeff[_29_] Excel Programming 1 April 7th 04 08:56 AM
closing excel after closing a workbook CWalsh[_2_] Excel Programming 3 January 21st 04 03:33 PM


All times are GMT +1. The time now is 06:01 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"