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: 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
------------------------------------------------------------------------------

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

--
Toby Erkson
Oregon, USA
Excel 2002 in Windows XP

"Bram Stolk" wrote in message ...
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: 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
------------------------------------------------------------------------------