Do you have a question? Post it now! No Registration Necessary. Now with pictures!
October 30, 2006, 5:35 am
rate this thread
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).
Re: run excel
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: