How to call a stored procedure in a macro

  • Thread starter Thread starter Lee Dengo
  • Start date Start date
L

Lee Dengo

Good morning,
How to call a stored procedure in Excel macro?
Thanks

Lee
 
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)
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run Macro If Cell have "x" value 0
Using Excel to call Oracle Stored procedure. 1
called macro 4
Call stored procedure in SSMS from Access 2016 doesn't work. 0
Calling Procedure from Cell value 3
How to Call a Store Procedure!!! 1
How to store values in excel using macro ? 4
Re: Reference must be to a macro sheet? 0

Back
Top