Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to call a stored procedure in a macro
Good morning,
How to call a stored procedure in Excel macro? Thanks Lee |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to call a stored procedure in a macro
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 |
#3
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hyperlink, macro, stored procedure? | Excel Worksheet Functions | |||
Stored Procedure call and passing parameters | Excel Programming | |||
execute stored procedure | Excel Programming | |||
Run a stored procedure in Excel 2K | Excel Programming | |||
Execute stored procedure using DAO | Excel Programming |