An error occurred while calling ASP to export the Excel file server. Createobject.

 

<% Set xlapplication = server. Createobject ("Excel. application") 'Call Excel Object %> Generally, an error occurs when the IIS server is not configured. The returned error message is as follows: Error Type: Server Object, ASP 0178 (0x80070005) Failed to call server. Createobject when checking the permission. Deny access to this object. The English version of the error message is as follows: Error Type: Server Object, ASP 0178 (0x80070005) The call to server. Createobject failed while checking permissions. access is denied to this object. This is a component that is not registered in IIS to use MS Excel. All calls may fail. The solution is as follows: Start-> Run-> dcomcnfg (Open component service) In DCOM configuration, find "Microsoft Excel application" (the name depends on the object you are calling ), Right-click and choose Properties> Security. In the "Start and activate Permissions" box, click "edit" to grant all three permissions to everyone (Window 2000 system. In fact, the first launch & activate is enough. If it is an XP system, everyone cannot be found. Therefore, I have added an IIS user: iuser/your user. If the user cannot be found, click "add"> "advanced ", use "Search now" to find the corresponding user. In XP, "Local startup" and "Local activation" are allowed in the permission selection box.