|
-
October 26th, 2010, 08:07 PM
#1
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
-
October 26th, 2010, 10:28 PM
#2
Re: What the hell does this mean--> 0x800A03EC HRESULT EXCEPTION
Probably don't have PERMISSION to create a file in that folder.
-
October 27th, 2010, 12:34 PM
#3
Re: What the hell does this mean--> 0x800A03EC HRESULT EXCEPTION
 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
-
October 27th, 2010, 03:08 PM
#4
Re: What the hell does this mean--> 0x800A03EC HRESULT EXCEPTION
We all learn... Please mark the thread RESOLVED using the TOOLS
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|