Create an Excel application Program Error:
Failed to retrieve components whose CLSID is {00024500-0000-0000-c000-000000000046} in the com class factory because of the following error: 80070005
Solution: configure the Excel application in DCOM:
To set up an Office Automation server under an interactive user account, follow these steps:
1. |
Log on to your computer as an administrator and use the full installation method to install (or reinstall) The office. To ensure system reliability, we recommend that you copy the content from the office CD-ROM to your local drive and install office from this location. |
2. |
Start the Office application that you want to run automatically. This forces the application to register itself. |
3. |
After running the application, press Alt + F11 to load the Microsoft Visual Basic for Applications (VBA) Editor. This forces VBA to initialize. |
4. |
Close the application, including VBA. |
5. |
ClickStart, ClickRunAnd then typeDcomcnfg. Select the application to run automatically. The Application name is as follows:Microsoft Access 97-Microsoft Access database Microsoft Access 2000/2002-Microsoft Access Application Microsoft Excel 97/2000/2002-Microsoft Excel application Microsoft Word 97-Microsoft Word basic Microsoft Word 2000/2002-Microsoft Word documentationClickAttributeOpen the Properties dialog box for this application. |
6. |
ClickSecurityTab. VerifyUse the default access permissionAndUse the default start permissionSelected. |
7. |
ClickIdentifierTab, and then selectInteractive User. |
8. |
ClickOKTo close the Properties dialog box and return to the main Application List dialog box. |
9. |
InDCOM ConfigurationIn the dialog box, clickDefault SecurityTab. |
10. |
ClickEdit Default Value. Verify that the following users are listed in the access permission. If not, add these users:System Interactive Everyone Administrators IUSR _ <machinename>* IWAM _ <machinename>**These accounts only exist when Internet Information Server (IIS) is installed on the computer. |
11. |
Make sure that each user is allowed to access, and then clickOK. |
12. |
ClickEdit Default Value. Verify that the following users are listed in the startup permission. If not, add these users:System Interactive Everyone Administrators IUSR _ <machinename>* IWAM _ <machinename>**These accounts only exist when IIS is installed on the computer. |
13. |
Make sure that each user is allowed to access, and then clickOK. |
14. |
ClickOKDisable dcomcnfg. |
ReferenceArticle: Http://support.microsoft.com/default.aspx? SCID = KB; ZH-CN; 288366
If you have used identity simulation (<identity impersonate = "true"/> configured in Web. config), you need to delete it !...