Whilst trying to load information from an Excel File I have, I get the following message:
System.Runtime.InteropServices.COMException (0x800A03EC): Exception from HRESULT: 0x800A03EC
from this:
from theCode:Dim strFileTeam As String Dim objExcel As Excel.Application Dim objWorkbook As Excel.Workbook Dim objSheet As Excel.Worksheet strFileTeam = My.Application.Info.DirectoryPath & "\teams.xlsx" objExcel = StartExcel(True) Try objWorkbook = objExcel.Workbooks.Add(strFileTeam) objSheet = objWorkbook.Sheets("Team1") MsgBox(objSheet.Cells("A", "1")) Catch ex As Exception MsgBox(ex.ToString) End Tryline in particularCode:objWorkbook = objExcel.Workbooks.Add(strFileTeam)
I am pulling my hair out... I need serious help guys




Reply With Quote