Excel files with VBScript

I can't seem to open and create Excel files with VBScript. Here's my code:

oExcel = CreateObject("Excel.Application")


It gives me this error:

Microsoft VBScript runtime error '800a01ad'

ActiveX component can't create object: 'Excel.Application'

I try it like this:

oExcel = Server.CreateObject("Excel.Application")

And it gives me this error:

Server object error 'ASP 0177 : 800401f3'

Server.CreateObject Failed

/FullReport.asp, line 7

800401f3

This is very frustrating. Any help would be very much appreciated.

Thanks.

 

doing that is telling the server to create an instance excel on the server via the launching of excel. This is prohibited.

 

Well how do you create an excel object?

 

You can't create an excel object on the server. What are you trying to accomplish?

 

The user will click on a button, and the information in the access database will be exported to an excel file and saved on their computer.

Thanks.

 

Your probably gonna have to call your host and see if they allow the creation of activex objects on the server...it is a security risk and may be disabled.

 

well the cool thing about excel is the data is essentially formatted in XML.. additionally, you can open HTML in it. HTML tables will be read by excel as columns and rows. You know where I'm going with this..

 

It's our own in house server. I'm working on an Intranet site.
How would I do what you're talking about? How can I send information to excel if I can't open an excel file?

Thanks,

 

you don't need to open excel to make an excel file.. just like you don't need to open notepad to make a text file.

hmm.this looks interesting.
http://www.4guysfromrolla.com/webtech/022801-1.shtml

 

Ah thank you. That is what I needed. Much obliged.

 

Actually, nevermind. I can't create the OWC.Spreadsheet object. It gives me the same error.

System.Web.HttpException: Could not create an object of type 'OWC.Spreadsheet'.

 

do you have office 2000 or higher installed on that server?

 

Ah it works now. Thanks. One thing though is that Microsoft documentation for this thing is absolutely horrid. How the crap do you horizontally center align something in a cell? I see the HAlignment property, but they don't give you the constants or values for it. What good is that?

 

it's probably a boolean. You have left, center or right.. so i would venture HAlignment=True is the way to go.