CreateObject("Excel.Application")

[olivia919]

dim oExcel as object
oExcel=CreateObject("Excel.Application")
It works perfectly on my local machine. Once I upload the applcation onto the Web Sever. I got the error:"cannot create ActiveX Component"
Does anyone know why it happens?
Thank you!!!!

Olivia

 

[ca8msm]

It's probably a permissions error that is restricting the ASPNET account. Have a look into that as a first point of call.


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[olivia919]

is the web server which hosts my application required to have excel installed?

 

[ca8msm]

Errr...yes if you want to create an excel application!!!


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[olivia919]

I was not sure about that. My thought is if I can open and write excel report in the web browser as long as i have Excel on my local machine without excel installed on the server.
So you are saying if I want to create excel object. Excel has to be installed?
Sorry i am new to this. I don't fully understand how it works

 

[ca8msm]

The key to how ASP.NET works is that the ASP stands for Active Server Pages. If you want your page to be able to create an Excel application then it is the server which has to do the work to create this page. Thos quite obviously menas that the server will have to have excel installed. Once the page has created the relevant HTML, this will be sent to the client whose browser will read the HTML and display it to the user.


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[olivia919]

Thanks for your help.....!!!

 

[ca8msm]

No problem. If you want to do some further reading on ASP.NET, I would suggest reading some of the articles at:

http://aspnet.4guysfromrolla.com/

____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.