Missing member exception in VB.net app accessing Excel

Copper Contributor

Here is my code that creates a missing member exception:

Dim app As New Excel.Application
Dim wb As Excel.Workbook
wb = app.Workbooks.Open(wbName)
Dim ws As Excel.Worksheet
ws = CType(wb.Worksheets(wsName), Excel.Worksheet)
ws = wb.ActiveSheet

Dim temval As Integer = ws.Cells(4, cc + cOff).value

 

When I turn on Option Strict: the above statement is flagged as an error saying that Late Binding is not allowed.

 

With Option Strict off I get the Missing Member exception at runtime.

 

Any advice would be greatly appreciated.

0 Replies