Controlling VB executable from Excel File

G

Guest

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?
 
N

NickHK

Graham,
You want to edit the VB6 app to achieve your goal or you working from VBA to
control the VB6 app ?

NickHK
 
G

Guest

I need to write VBA in Excel so that when the User closes the Excel file the
VB executable also closes.
 
T

Tim Williams

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

An executable file to run a VB script? 14
Run file from VB in Excel 4
Excel macro to VB executable 1
starting Word from an Excel macro 3
closing a vba project - dumb question 2
Closing VB triggers closing Excel 2
batch file call from a macro - how ? and required batch format 3
Opening an Excel spreadsheet from within an Excel spreadsheet 2

Top