I installed Excel on the server this afternoon and completed a reboot.
Main Topics
Browse All TopicsI have created an Intranet site here at my organization and as part of my project they want me to have form data output automatically to excel documents. I have written a VBScript to do this and although it works great on my local system for testing, once I uploaded it to the IIS server it is throwing me the error:
ActiveX component can't create object: 'Excel.Application'
Can anyone help me with this? I installed Excel on the server thinking that this would resolve the issue, but it did not.
If there is an alternate way to configure this altogether that would work too. I mainly need to be able to take the data input to web forms and have it automatically output to an excel doc.
Thank you!
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.

Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
This article should help you out. There is probably a problem with the automation object for Excel. Pay extra attention to the "Examine the automation server" section.
http://support.microsoft.c
I am thinking that the problem might possibly have to do with the scripting for where the tmplate file is located. I have it set to MaterialsRequestForms/ which is a folder located within the WebSite, then the script later calls the file itself, which is located within this folder. Does this look correct?
Disabling AV did not resolve the issue either.
On one of the clients you could try going in to Component Services and changing the DCOM permissions for Microsoft Excel so that anonymous has rights to all of them. (Make sure you remove these permissions after the test because from a security standpoint they could be a problem).
Also try adding the website to the trusted zone in IE.
Ok, I found the fix. As this was an ActiveX issue, I was able to resolve by going to the client workstation, opening IE > Tools > Internet Options > Security > (Internet Zone) Custom Level > and set the Initialize and Script ActiveX controls not marked as safe for scripting option under ActiveX controls and plug-ins.
The only question I have on this though is, will this negatively effect internet browsing? I obviously just opened a hole in the security, but is it major?
Business Accounts
Answer for Membership
by: BadotzPosted on 2007-12-05 at 15:38:24ID: 20416268
Sounds like Excel is not installed on the server.