Cannot load Excel file

[angelica]

Hi,

I am trying to load an excel file from vb.net. this is all new to me and I have tried this code :

Private Sub MenuItem4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)
        Dim xlbook As Microsoft.Office.Interop.Excel.Application = New Excel.Workbook
        Dim wb As Microsoft.Office.Interop.Excel.Workbook
        Dim filestring As String = ("C:\My Documents\VBA")
        Try
            xlbook = CType(CreateObject("Excel.Application"), Microsoft.Office.Interop.Excel.Application)
 
            wb = xlbook.Workbooks.Open(filestring & "\trial vba.xls")
 
            xlbook.Visible = True
            'wb.Activate()
        Catch ex As Exception
            MessageBox.Show("Error: " + ex.ToString())
        End Try
 
    End Sub

Can someone please help.

I also need to load the file in a datagrid but I dont know how to do this since I always loaded Access database table. Please give me some examples. Thanks.

[RobDog888]

You setting a workbook variable equal to a application object. It needs to be the same.

Dim xlApp As Microsoft.Office.Interop.Excel.Application
Dim xlbook As Microsoft.Office.Interop.Excel.Workbook