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

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