Export Vb.net Datagridview to Microsoft Excel 2013

[Benniit]

Please I'm using vb.net 2013 and Microsoft office 2013. The below code is able to display the datagridview

into excel 2007. But the code does not display onto excel 2013 and no error gets reported. I suspect the

excel 2013 format could be the cause but i do not know how to go about it. Please help me out. Thanks, Ben

 
Dim ExcelApp As Object, ExcelBook As Object
        Dim ExcelSheet As Object
        Dim i As Integer
        Dim j As Integer
 
        'create object of excel
        ExcelApp = CreateObject("Excel.Application")
        ExcelBook = ExcelApp.WorkBooks.Add
        ExcelSheet = ExcelBook.WorkSheets(1)
 
        With ExcelSheet
            For i = 1 To Me.DataGridViewGCL.RowCount
                .cells(i, 1) = Me.DataGridViewGCL.Rows(i - 1).Cells("GclNo").Value
                For j = 1 To DataGridViewGCL.Columns.Count - 1
                    .cells(i, j + 1) = DataGridViewGCL.Rows(i - 1).Cells(j).Value
                Next
            Next
        End With
 
        ExcelApp.Visible = True
        '
        ExcelSheet = Nothing
        ExcelBook = Nothing
        ExcelApp = Nothing
 
 

[juster21]

Have you stepped through the code at all? Does it fail at a certain place?