[RESOLVED] Late binding error when accessing an excel spreadsheet

[John_SC]

When I have Options Strict On, I get a Late Binding error when trying to access cells in an Excel Spreadsheet. The error goes away if I set Options Strict Off, but I would prefer to keep it on. Here is a snip-it of code.

Imports Excel = Microsoft.Office.Interop.Excel

Public Class Form1

    Dim APP As New Excel.Application
    Dim worksheet As Excel.Worksheet
    Dim workbook As Excel.Workbook

    Private Sub btnRead_Click(sender As Object, e As EventArgs) Handles btnRead.Click
        TextBox1.Text = worksheet.Cells(1, 1).Value.ToString   ' Late Binding Error

        TextBox2.Text = worksheet.Cells(1, 2).Value.ToString   ' Late Binding Error

    End Sub

    Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
        workbook = APP.Workbooks.Open(Application.StartupPath & "\temp.xlsx")
        worksheet = CType(workbook.Worksheets("sheet1"), Excel.Worksheet)
    End Sub
End Class

Note, I have added a reference to Microsoft Excel 14.0 Object Library. Any idea on how to resolve this?