Releasing reference to the Application object before exiting
The Workbook of the Add-In contains the following code:
Private WithEvents MyExcelApp As Excel.Application
Private Sub Workbook_Open()
If MyExcelApp Is Nothing Then
Set MyExcelApp = ThisWorkbook.Application
End If
End Sub
Before exiting Excel, which event in the Add-In's Workbook will allow me to
release the reference (MyExcelApp) to the application?
|