Hi
I have a stored procedure on SQL Server 2000 called:
[Busobjects].Capacity_Planning.dbo.sp_flickimp_test
I have an Excel Sheet with the 2 paramters for the Stored procedure in cells A1 and B1.
How do I execute a SQL Stored procedure from Excel pulling through the variables?
Someone told me to use:
----------------------------------------------------
dim cnn as adodb.connection
set cnn = new adodb.connection
cnn.open Connection
dim cmd as adodb.command
set cmd = new adodb.command
set cmd.activeconnection = cnn
cmd.commandtype = "dbo.sp_Flickimp_test"
cmd.parameters.append cmd.createparameter("@Type", adVarchar, adParamInput, 3, range("A1").value2)
cmd.parameters.append cmd.createparameter("@LSS", adVarchar, adParamInput, 3, range("B1").value2)
dim rs as adodb.recordset
set rs = new adodb.recordset
rs.open cmd
-----------------------------------------
But I dont understand this?
I need step by step instructions on what to do.
Please help?!!?!?!?!?!?