Hi,

How to call a stored proc with parameters from Excel VBA? Withou
parameters, it goes something like -

.................................................. ......
Set Comm = New ADODB.Command
Comm.ActiveConnection = Conn
With Comm
.CommandText = <STORED PROC NAME
.CommandType = adCmdStoredProc
.Execute
End With
.................................................. ......

But I am not able to call SP with multiple parameters. Can someon
help please.

Thanks in advance,

Harish Mohanbab

--
Harish Mohanba

-----------------------------------------------------------------------
Harish Mohanbab's Profile: http://www.excelforum.com/member.php...nfo&userid=633
View this thread: http://www.excelforum.com/showthread.php?threadid=46818