Posted to microsoft.public.excel.programming
|
|
How to call a stored procedure in a macro
Thanks Bob
-----Original Message-----
Lee,
Spookily,we had the same question earlier.
This is what I offered then
You can use ADO to invoke a SP from Excel, including
parameters.
I could knock up some code myself, but I found this
example on the net. Not
sure how good it is but give it a try
http://www.midrangeserver.com/mgo/mg...3-story01.html
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Lee Dengo" wrote
in message
...
Good morning,
How to call a stored procedure in Excel macro?
Thanks
Lee
.
|