What the hell does this mean--> 0x800A03EC HRESULT EXCEPTION
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:
Code:
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 Try
from the
Code:
objWorkbook = objExcel.Workbooks.Add(strFileTeam)
line in particular
I am pulling my hair out... I need serious help guys
Re: What the hell does this mean--> 0x800A03EC HRESULT EXCEPTION
Probably don't have PERMISSION to create a file in that folder.
Re: What the hell does this mean--> 0x800A03EC HRESULT EXCEPTION
Quote:
Originally Posted by
dglienna
Probably don't have PERMISSION to create a file in that folder.
THANK YOU! I'm an idiot... I'm not creating one, I'm opening one... its .Open() not .Add
Thanks again dglienna, when you stated "create a file" it clicked and I laughed for about an hour because of my stupidity
Re: What the hell does this mean--> 0x800A03EC HRESULT EXCEPTION
We all learn... Please mark the thread RESOLVED using the TOOLS