We have a windows Service application which uses Excel Application Object. It used to work on some machines but not all, the error which I am getting is:
Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005.
After some struggling I found a solution and it works, solution is:
Solution 1:
- Create directory C:\Windows\SysWOW64\config\systemprofile\Desktop (for 64 bit Windows) or C:\Windows\System32\config\systemprofile\Desktop (for 32 bit Windows) and give full permission
- Run program “dcomcnfg” Go to “Console Root/Component Services/Computer/My Computer/DCOM Config/” Look up Microsoft Excel and choose properties.
- Go to Security and Launch and activation permissions->customize->add network, network service, administrator, interactive, system and everyone and give full access
- Now go to “Identity” and select “The interactive user”.
- Now go to “Console Root/Component Services/Computer/My Computer”, right click Properties of “My Computer”, give full access permission to all users.
- Solution 2:
<system.web>
<identity impersonate=”true” userName=”domain\jack” password=”********” />
</system.web>
Leave a Reply