run excel

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
I want to run excel in server.
Server have IIS and MS SQL.

My plan is, get data from MS sql and attach it in excel and run
macro(vba) get result(exactly, chart) and save it as htm in server.

I know it's weird, but I can run it in excel and don't want to write
code again. (actually have no idea).

So, my question is, load excel and run it (vba).
Thank you.

Re: run excel

kirke wrote:

Quoted text here. Click to load it

Yes, that is possible.
You should however avoid that solution like hell.
Creating M$ Office serverside object and manipulate them is called  
'automation', and is well known for its memoryleaks and bugs.
It is also a M$-only solution. If you switch server to a real OS, it will  

If you still want to go that road, start here:

Erwin Moller

Site Timeline