954,566 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

Unable to get the Open property of the Workbooks class

Hi everyone i am getting an error that says Microsoft Office Excel error '800a03ec'
Unable to get the Open property of the Workbooks class when i try to open an excel work book in my code . The line of code where i get the error is Set ExcelBook = ExcelApp.Workbooks.open(BookPath) where BookPath is the path to the file .
The code before the line where the error is looks like this
Set ExcelApp = CreateObject("Excel.Application")
ExcelApp.Application.Visible = false
BookPath = "c:\filename.xls"
Set ExcelBook = ExcelApp.Workbooks.open(BookPath)

please help and thank you in advance

PotaZinga
Newbie Poster
16 posts since Jul 2010
Reputation Points: 10
Solved Threads: 0
 

hi!

here is a solution that worked for me .


・Windows 2008 Server x64

Please make this folder.

C:\Windows\SysWOW64\config\systemprofile\Desktop

・Windows 2008 Server x86

Please make this folder.

C:\Windows\System32\config\systemprofile\Desktop

and do not forget to give relevant rights to those folders .

http://social.msdn.microsoft.com/Forums/en-US/innovateonoffice/thread/b81a3c4e-62db-488b-af06-44421818ef91?prof=require

PotaZinga
Newbie Poster
16 posts since Jul 2010
Reputation Points: 10
Solved Threads: 0
 

This question has already been solved

Post: Markdown Syntax: Formatting Help
You