call Excel subroutine from Sql Server?

N

news.microsoft.com

Hi,

What are my options for calling an Excel VBA subroutine (let's say it's in
"ThisWorkbook") from TSQL in Sql Server?

if i could invoke Excel.exe with a command line parameter to call the
subroutine, that might work. But that is not an available command line
option, as i understand it. I could manipulate the object model from within
TSQL is another option.

Has anyone achieve this, or have any pointers?

Thanks,

Fred
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top