call Excel subroutine from Sql Server?
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
|