468,268 Members | 1,657 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,268 developers. It's quick & easy.

run excel

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.

Oct 30 '06 #1
1 1423
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
Oct 30 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

13 posts views Thread by Allison Bailey | last post: by
6 posts views Thread by Matthew Wieder | last post: by
14 posts views Thread by pmud | last post: by
22 posts views Thread by Howard Kaikow | last post: by
7 posts views Thread by Alain \Mbuna\ | last post: by
9 posts views Thread by Doug Glancy | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by zattat | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.