Steakk

    Private Sub WriteToExcel(ByVal filename As String)
        'If file already exists, remove it  
        'If File.Exists(xlsSaveFile) Then File.Delete(xlsSaveFile)
        Try
            theWorkbook = oWorkbooks.Open("C:\cbcs.xls")
            oSheet = MyExcel.ActiveSheet
            oSheet.Name = "Inventory List"
            oSheet.Range("B4").Value = "Cabling"
            oSheet.Range("C4").Value = "100"
            oSheet.Range("D4").Value = "0.26"
            theWorkbook.SaveAs("C:\cbcs2.xls")
            theWorkbook.Close()
            MyExcel.Quit()
            GC.Collect()
            GC.WaitForPendingFinalizers()
        Catch ex As Exception
            Throw New Exception("Error creating Excel spreadsheet:" & ex.Message.ToString())
        Finally
            oSheet = Nothing
            theWorkbook = Nothing
            oWorkbooks = Nothing
            MyExcel = Nothing
        End Try
    End Sub