Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel object event handling
Hello,
I need to handle an Excel.Workbook.BeforeClose event in my VB.NET application. When the framework attempts to bind the event with my handler, it throws a System.InvalidCastException with message "No such interface supported". I included the relevant declarations: Imports Excel .... Public Class TimeReportSheet .... Private WithEvents excelWorkBook As Workbook .... Public Sub Form(... Dim excelApp As Excel.Application = Nothing excelApp = New Excel.Application() ... excelWorkBook = excelApp.Workbooks.Add() ' the exception is thrown here ... End Sub Private Sub Workbook_BeforeCloseEventHandler(ByRef Cancel As Boolean) Handles excelWorkBook.BeforeClose Cancel = False End Sub .... End Class ------------- I have Microsoft Development Environment 2002 version 7.0.9466, Microsoft ..NET Framework 1.0 version 1.0.3705, Microsoft Excel 11.0 Object Library, MS Office 2003 What do I wrong? Thanx |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel object event handling
The answer is the
Microsoft Knowledge Base Article - 316653 (http://support.microsoft.com/default.aspx?kbid=316653) "Vladimir Kryachko" wrote in message ... Hello, I need to handle an Excel.Workbook.BeforeClose event in my VB.NET application. When the framework attempts to bind the event with my handler, it throws a System.InvalidCastException with message "No such interface supported". I included the relevant declarations: Imports Excel ... Public Class TimeReportSheet ... Private WithEvents excelWorkBook As Workbook ... Public Sub Form(... Dim excelApp As Excel.Application = Nothing excelApp = New Excel.Application() ... excelWorkBook = excelApp.Workbooks.Add() ' the exception is thrown here ... End Sub Private Sub Workbook_BeforeCloseEventHandler(ByRef Cancel As Boolean) Handles excelWorkBook.BeforeClose Cancel = False End Sub ... End Class ------------- I have Microsoft Development Environment 2002 version 7.0.9466, Microsoft .NET Framework 1.0 version 1.0.3705, Microsoft Excel 11.0 Object Library, MS Office 2003 What do I wrong? Thanx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
perform an event if mouse rolled over an object | Excel Worksheet Functions | |||
checkbox event handling function | Excel Worksheet Functions | |||
Object vs Picture Handling in Different Versions of Excel | Excel Discussion (Misc queries) | |||
Excel Error Handling | Excel Programming | |||
OLE Excel data handling from VB | Excel Programming |