Sep 26 2022
Here is my code that creates a missing member exception:
Dim app As New Excel.ApplicationDim wb As Excel.Workbookwb = app.Workbooks.Open(wbName)Dim ws As Excel.Worksheetws = 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.