Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-24-2010, 08:22 PM
sword.fish sword.fish is offline Excel Open throws  0x800A03EC error Windows 2K Excel Open throws  0x800A03EC error Office 2003
Novice
Excel Open throws  0x800A03EC error
 
Join Date: Feb 2010
Posts: 3
sword.fish is on a distinguished road
Default Excel Open throws 0x800A03EC error

Hi

we have moved from win2003 to win 2008/IIS7

The ASP.NET application generates excel 2003 reports, and it used to work fine, after the migration it stopped working.

I need to give permissions to Microsoft Excel Application which was missing in DCOM config on windows 2008. I did the following to give Excel permissions.

1. In DCOMCNFG, right click on the My Computer and select properties.
2. Choose the COM Securities tab
3. In Access Permissions, click "Edit Defaults" and add Network Service to it and give it "Allow local access" permission. Do the same for <Machine_name>\Users.
4. In launch and Activation Permissions, click "Edit Defaults" and add Network Service to it and give it "Local launch" and "Local Activation" permission. Do the same for <Machine_name>\Users

Press OK and thats it. now I can create the instance of Excel as follows:
oexcel = New Microsoft.Office.Interop.Excel.Application

BUT the problem is, the following code is breaking:
obook = oexcel.Workbooks.Open(mfilename)

The error from the event log is as follows:

General Information
*********************************************
Additional Info:
ExceptionManager.MachineName: M1NAPP1
ExceptionManager.TimeStamp: 25/02/2010 3:34:55 p.m.
ExceptionManager.FullName: Microsoft.ApplicationBlocks.ExceptionManagement, Version=1.0.1796.30304, Culture=neutral, PublicKeyToken=null


ExceptionManager.AppDomainName: /LM/W3SVC/1/ROOT/m1Central-5-129115366562744140
ExceptionManager.ThreadIdentity: pmotupally
ExceptionManager.WindowsIdentity: IIS APPPOOL\Classic .NET AppPool
1) Exception Information
*********************************************
Exception Type: System.Runtime.InteropServices.COMException
ErrorCode: -2146827284
Message: Exception from HRESULT: 0x800A03EC
Data: System.Collections.ListDictionaryInternal
TargetSite: Microsoft.Office.Interop.Excel.Workbook Open(System.String, System.Object, System.Object, System.Object, System.Object, System.Object, System.Object, System.Object, System.Object, System.Object, System.Object, System.Object, System.Object, System.Object, System.Object)
HelpLink: NULL
Source: Microsoft.Office.Interop.Excel
StackTrace Information
*********************************************
at Microsoft.Office.Interop.Excel.Workbooks.Open(Stri ng Filename, Object UpdateLinks, Object ReadOnly, Object Format, Object Password, Object WriteResPassword, Object IgnoreReadOnlyRecommended, Object Origin, Object Delimiter, Object Editable, Object Notify, Object Converter, Object AddToMru, Object Local, Object CorruptLoad)
at AgencySetup.RptAgencyCampMain.ExportToExcel(DataSe t ds)
General Information
*********************************************
Additional Info:
ExceptionManager.MachineName: M1NAPP1
ExceptionManager.TimeStamp: 25/02/2010 3:34:55 p.m.
ExceptionManager.FullName: Microsoft.ApplicationBlocks.ExceptionManagement, Version=1.0.1796.30304, Culture=neutral, PublicKeyToken=null
ExceptionManager.AppDomainName: /LM/W3SVC/1/ROOT/m1Central-5-129115366562744140
ExceptionManager.ThreadIdentity: pmotupally
ExceptionManager.WindowsIdentity: IIS APPPOOL\Classic .NET AppPool
1) Exception Information
*********************************************
Exception Type: System.Runtime.InteropServices.COMException
ErrorCode: -2146827284
Message: Exception from HRESULT: 0x800A03EC
Data: System.Collections.ListDictionaryInternal
TargetSite: Microsoft.Office.Interop.Excel.Workbook Open(System.String, System.Object, System.Object, System.Object, System.Object, System.Object, System.Object, System.Object, System.Object, System.Object, System.Object, System.Object, System.Object, System.Object, System.Object)
HelpLink: NULL
Source: Microsoft.Office.Interop.Excel
StackTrace Information
*********************************************
at Microsoft.Office.Interop.Excel.Workbooks.Open(Stri ng Filename, Object UpdateLinks, Object ReadOnly, Object Format, Object Password, Object WriteResPassword, Object IgnoreReadOnlyRecommended, Object Origin, Object Delimiter, Object Editable, Object Notify, Object Converter, Object AddToMru, Object Local, Object CorruptLoad)
at AgencySetup.RptAgencyCampMain.ExportToExcel(DataSe t ds)


Your help will be greatly appreciated,

Thanks in advance
Reply With Quote
  #2  
Old 06-10-2010, 09:23 AM
Tobi Tobi is offline Excel Open throws  0x800A03EC error Windows 7 Excel Open throws  0x800A03EC error Office 2003
Novice
 
Join Date: Jun 2010
Posts: 1
Tobi is on a distinguished road
Default

I am having this exact issue. Did you by chance find a fix for this?

Thanks.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Open throws  0x800A03EC error Excel won't open maximized from URL jdanton Excel 2 09-24-2009 08:11 AM
Receive error cannot open this form because an error occurred in BCM 2007 bornhusker Outlook 0 06-01-2009 10:28 AM
Excel Open throws  0x800A03EC error Some Excel File Will Not Open cgoodlein Excel 5 05-19-2009 04:46 AM
Excel Open throws  0x800A03EC error Application not found error when trying to open .pdf files. Dave Outlook 2 12-15-2005 01:01 PM
Publisher open file error bek Publisher 1 11-08-2005 09:51 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:43 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft