Excel - Word Automation from VB 6

[chindas]

Hi all,

I have a VB6 app who manages a word doc. I use BeforeSave event to control whether the doc must be saved. And the Terminate event to Set oAppWord = Nothing.

'Object declaration at form level
Dim WithEvents oAppWord As Word.Application
Dim WithEvents oAppExcel As Excel.Application

I´m trying to do something similar with an Excel object, but the Terminate event doesn´t exist, so I can´t Set oAppExcell = Nothing, and I can´t find any other event valid for this purpose..

Any ideas?

 

[chindas]

Oops, sorry, i mean Quit event in place of Terminate event..