Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Controlling VB executable from Excel File
I have a VB 6.0 exectutable that opens a specific Excel 97 file and contains
a timer event to close the Excel file if dormant. This works well. I need to add a further control such that on closing the Excel 97 file the VB executable also closes. Any ideas how to do this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Controlling VB executable from Excel File
Graham,
You have the source code the VB app ? NickHK "Graham Masters" wrote in message ... I have a VB 6.0 exectutable that opens a specific Excel 97 file and contains a timer event to close the Excel file if dormant. This works well. I need to add a further control such that on closing the Excel 97 file the VB executable also closes. Any ideas how to do this? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Controlling VB executable from Excel File
Nick,
Not sure what you mean! "NickHK" wrote: Graham, You have the source code the VB app ? NickHK "Graham Masters" wrote in message ... I have a VB 6.0 exectutable that opens a specific Excel 97 file and contains a timer event to close the Excel file if dormant. This works well. I need to add a further control such that on closing the Excel 97 file the VB executable also closes. Any ideas how to do this? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Controlling VB executable from Excel File
Graham,
You want to edit the VB6 app to achieve your goal or you working from VBA to control the VB6 app ? NickHK "Graham Masters" wrote in message ... Nick, Not sure what you mean! "NickHK" wrote: Graham, You have the source code the VB app ? NickHK "Graham Masters" wrote in message ... I have a VB 6.0 exectutable that opens a specific Excel 97 file and contains a timer event to close the Excel file if dormant. This works well. I need to add a further control such that on closing the Excel 97 file the VB executable also closes. Any ideas how to do this? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Controlling VB executable from Excel File
I need to write VBA in Excel so that when the User closes the Excel file the
VB executable also closes. "NickHK" wrote: Graham, You want to edit the VB6 app to achieve your goal or you working from VBA to control the VB6 app ? NickHK "Graham Masters" wrote in message ... Nick, Not sure what you mean! "NickHK" wrote: Graham, You have the source code the VB app ? NickHK "Graham Masters" wrote in message ... I have a VB 6.0 exectutable that opens a specific Excel 97 file and contains a timer event to close the Excel file if dormant. This works well. I need to add a further control such that on closing the Excel 97 file the VB executable also closes. Any ideas how to do this? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Controlling VB executable from Excel File
How about a second (more frequent) timer in the VB app which checks to see
if the opened file is still open. If the file is closed then the app closes itself. That saves you from replicating the "close vb app" code across multiple workbooks. -- Tim Williams Palo Alto, CA "Graham Masters" wrote in message ... I have a VB 6.0 exectutable that opens a specific Excel 97 file and contains a timer event to close the Excel file if dormant. This works well. I need to add a further control such that on closing the Excel 97 file the VB executable also closes. Any ideas how to do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
getting an excel file to run as an executable | Excel Discussion (Misc queries) | |||
How can generate an executable file from Excel? | Excel Discussion (Misc queries) | |||
Convert excel file to executable file | Excel Discussion (Misc queries) | |||
Excel file as an executable? | Excel Programming | |||
Is there a way to make Excel file an executable? | Excel Programming |