Pause program execution until other application finishes
Make it a specific workbook, not just any old one. That
way, you can put in its Workbook_BeforeClose event the
code to call the function you want called when they've
done the Excel stuff. Alternatively, if you don't want
them to do anything else while Excel is in operation, have
your application quit when Excel has started, and have the
Workbook_BeforeClose event Shell your application with a
certain command line argument, then you can find out
whether this was used and what it was with the Command$
variable.
Quote:
>-----Original Message-----
>I have an application that launches excel and displays a
particular
>workbook. I need to pause program execution until the
user closes the
>workbook. can anyone give me information on how to do
this.
>TIA
>Chris
>.
