471,046 Members | 1,286 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,046 software developers and data experts.

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 1490
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

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.