View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
cgr cgr is offline
external usenet poster
 
Posts: 4
Default 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?