Calling a stored procedure from VBA

[markSaunders]

I have an application in VBA (word2000) and have managed to get my first recordset form the standard SQL(2000) SELECT statement.

I now need to run a stored procedure, passing in the paramaters selected by the user.

I have everything setup except the actual syntax for calling a SQL Stored Proc.

any help/advice/pointers would be appreciated

cheers
mark Mark Saunders

 

[mikewoodhouse]

Try something like

sql = "exec mystoredproc numberparam, 'stringparam'"

Set myRecordSet = New ADODB.Recordset

myRecordSet.Open sql, myConnection

... or delve into the mysteries of the ADO Command and Parameter objects (which you may just find to be more trouble than you need right now!)

HTH

 

[jimmythegeek]

If you are really up for the Command and Parameter objects (which is what you need to use to pass parameters into and receive them back from a SQL Server stored procedure), see the following thread. If you still need help, copy and paste what doesn't make sense here, and we can look at it for you.

thread705-242764 Jim Lunde
compugeeks@hotmail.com
We all agree your theory is crazy, but is it crazy enough?