Quit event missing in Excel.

B

Bram Stolk

Hi There,

I am accessing excel via COM using Python, but Python's interface is
identical to that of VBA.

Using events, I can catch the closing of a workbook.
However, I need to perform some tasks upon closing of the entire
excel application.

Strangely enough, there is no Quit event defined for Excel, whereas
MS-Word does have a quit event.

How can I have my code triggered upon application exit?

Thanks,

Bram Stolk


--
------------------------------------------------------------------------------
Bram Stolk, VR Engineer.
SARA Academic Computing Services Amsterdam, PO Box 94613, 1090 GP AMSTERDAM
email: [email protected] Phone +31-20-5923059 Fax +31-20-6683167

"Software is math. Math is not patentable."
OR
"Software is literature. Literature is not patentable." -- slashdot comment
------------------------------------------------------------------------------
 
T

Toby Erkson

Excel has a workbook event:
Private Sub Workbook_BeforeClose(Cancel As Boolean)
End Sub
You could use that as a trigger.
 
Top