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