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?