Microsoft Excel Application entry missing in DCOMCNFG
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.
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
Keyboard Labtec Media Desktop Y-SAD65 Mouse Razer DeathAdder 3G Infrared Sensor (1800DPI) PSU ANTEC 750w Earthwatts Case Thermaltake Shark (VA7000SWA ATX) Full Tower Cooling Front 120mm fan (1400 RPM) /Rear 120mm (1400 RPM) blue LED Hard Drives 2x Barracuda 7200.10 SATA 3.0Gb/s 160-GB Hard Drive ST3160815AS (AHCI) Internet Speed Telstra BigPond Elite Liberty ADSL2+ 24Mbps/256kbps Other Info ASUS PCE-N13 802.11n Wireless LAN card
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.
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 ?
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.
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
Please make this folder.
C:\Windows\SysWOW64\config\systemprofile\Desktop
・Windows 2008 Server x86
Please make this folder.
C:\Windows\System32\config\systemprofile\Desktop