Sometimes we do need an operation after the page fully loaded. This we can check with $ajaxStop() handler of the jquery.
$( document ).ajaxStop(function() { $( ".message" ).text( "Page load complete." );});
How to fix CLSID {00024500-0000-0000-C000-000000000046} error when using excel component in background code?
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>