Microsoft Excel Application entry missing in DCOMCNFG

[irfangani]

Hi I'm using windows 7 home premium. I have an application in ASP.Net which uses Excel Application Object. It used to work fine in XP but in Windows 7 I'm getting an error as mentioned below:

Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005.

I need to give permissions to Microsoft Excel Application in DCOM config but I can't seem to find this in windows 7. It used to be there in earlier versions but now its not there. I tried to reinstall Office 2007 but still I couldn't find it in DCOM config. Please suggest where I can give permissions to MS Excel Application so that my application runs without errors.

Thanks
Irfan

 

[Crispy]

1. Control Panel -> Administrative Tools -> Component Services
2. Console Root -> Component Services -> Computers -> My Computer -> DCOM Config
3. Right-Click 'Microsoft Excel Application' and choose Properties
4. Click 'Security' tab
5. Customize 'Launch and Activation Permissions'
6. Add the local ASPNET user and give it all permissions

 

[irfangani]

Re:

Thanks for the reply.. the problem is that there is no "Microsoft Excel Application" in dcomcnfg.. I'm not able to find it there. I reinstalled Office 2007 also, but still I couldn't find it there.

 

[erakis]

I have the same problem. I took a look in the registry to find the correct CLSID from the appID but I did not found anything. Is there any workaround or solution ?

Best regards

 

[irfangani]

I found a solution to this problem by giving permissions at system level by following the steps below
1. go to DCOMCNFG
2. In the left tree structure, right click on My Computer and select Properties
3. Click on COM SECURITY tab
4. Give Permissions to Network Service and Users in the "Access Permissions" and "Launch and Activation Permissions" by clicking the Edit Default buttons.

Now check your application.

 

[DanTheStan]

This does not fully work. Having changed the settings according to your solution, I could create excel reports (via asp.net, iis and office). however, a day later, this no longer worked although the permissions are still assigned to the network account (and the account of the iis pool). There must be another setting that affects using Office/Excel in IIS 7.5 on Windows Server 2008/Windows 7

Any help is appreciated

 

[sam constantine]

Use MMC comexp.msc /32 on win7 x64

 

[Japheth]

This solution is ...
・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