?
Solved

Unable to get the Open property of the Workbooks class

Posted on 2011-10-22
1
Medium Priority
?
4,442 Views
Last Modified: 2012-05-12
Hi Experts,

I am trying to work with Excel files from my classic ASP web application. It was working few days ago but today it stopped working suddenly. Perhaps it is due to some automatic windows updates. Here is a snippet of code that gives error:

dim objApp
dim objBook

set objApp = Server.CreateObject("Excel.Application")
set objBook = objApp.Workbooks.Open(server.MapPath("MyExcel.xls"))

While executing this code, it gives the following error:

Microsoft Office Excel error '800a03ec'
Unable to get the Open property of the Workbooks class

The same code works on my desktop and earlier it was working on the server also.
The server configuration is - Windows Server 2008 R2 x64, Microsoft Office 2007, IIS 7.5

Thanks in advance for all your efforts to sort out this issue.
0
Comment
Question by:timerack
1 Comment
 

Accepted Solution

by:
timerack earned 0 total points
ID: 37010877
Goto Component Services -> Excel -> Properties -> Identity tab -> choose This User - Administrator account.
It fixed the issue.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question