Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Folks
I have a pretty standard class I use to trap application events ----------------------------------------------------------------- Option Explicit Public WithEvents myApp As Excel.Application Private Sub myApp_WorkbookBeforeClose(ByVal Wb As Workbook, Cancel As Boolean) ' - Traps the close event ' DO STUFF End Sub ----------------------------------------------------------------- Which I initialize using this code snippet ----------------------------------------------------------------- Public gThisApp As clsApplication Set gThisApp.myApp = Excel.Application ----------------------------------------------------------------- Resulting in the following error Object variable or With block variable not set <<< I'm pretty sure this was working just fine before applying 2003SP1... Am I missing something obvious ? Any pointer ? Thanks & regards --AlexT |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Application level event help | Excel Discussion (Misc queries) | |||
where is the workbook_open event handler??? | Excel Programming | |||
different IDispatch in event handler | Excel Programming | |||
Cell Event Handler | Excel Programming | |||
Monitoring application-level event problem | Excel Programming |