How to call a stored procedure in a macro

B

Bob Phillips

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/mgo102203-story01.html


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
L

Lee

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/mgo102203-story01.html


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)




.
Click to expand...
 
Top