Posted by Erwin Moller on 10/30/06 09:23

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

[Back to original message]