run excel

[kirke]

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).
possible?
Thank you.

[Erwin Moller]

Re: run excel

kirke wrote:

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).
possible?
Thank you.

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
fail.

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

http://nl3.php.net/manual/en/ref.com.php

Regards,
Erwin Moller