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
 
Top