For Programmers: Free Programming Magazines  


Home > Archive > ASP > October 2006 > run excel









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author run excel
kirke

2006-10-30, 9:55 pm

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

Bob Barrows [MVP]

2006-10-30, 9:55 pm

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

http://support.microsoft.com/defaul...kb;en-us;257757
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com