Sep 26 2022 12:16 PM
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.