How to automatically reconnect application events after a crash ?

[Dave2]

Application events are fired through the existence of a single object of type
"ClassApplicationEvents", for lack of a better class name.

This object variable dies when the application crashes.

I'm looking for a robust way to automatically recreate this object variable after a crash, hopefully without making the user invoke a macro.

Any ideas?

 

[iliace]

Generally, you would create your own class and include an object using WithEvents keyword. E.g.

Dim WithEvents xlApp As Excel.Application

To test whether it has crashed, do a test

If xlApp Is Nothing Then
' ....

would that work?

As far as "robust", you would probably need to be recording any data or parameters along the way, which can get complicated.

 

[Dave2]

The problem with your proposed solution is that user interaction with the application which you desire to "listen to" via application events may already be going on before the test and possible resurrection of the object variable you describe has been carried out.

 

[Jaafar Tribak]

When a vbproject crash happens all variables are released including the variable holding the 'ClassApplicationEvents' class instance .

One way you could try is to reset the variable in a windows timer periodically say every second ... Not an elegant solution but should accomplish what you want.