PDA

View Full Version : How To Run A Stored Procedure with dynamic variables in EXCEL



Noelskie
2014-11-26, 04:26 PM
Good Morning Guys,

I Would like to ask how could you run a stored procedure that has dynamic variables(Will Allow you to input variables before you run the stored procedures). i am trying to use a stored procedure by calling it in. i have attached my connection settings and hopefully you can help me guys on this problem. by the way, i am using excel 2013 to run my stored procedure.

Many Thanks,

Noel


2892

Bob Phillips
2014-11-26, 06:15 PM
I always use ADO and call the stored procedure using the Command object, in which you can set parameters.