Guys its a little tricky question...

I do not know how many of you are familiar of Stored Procedure calling conventions from VB. But there are two ways I am interested in right now ....

1. Either create the command object and add the SP parameters to it using append method ..

2. or directly call the SP using connection object.

connection.spname param, recordset

where spname = stored procedure name
param = parameter
Recordset = Result Recordset (SP Return)

Now the thing is in this method i have to hardcode the stored procedure name after connection. to make it work.

Is there a way to pass a string variable containing the store procedure name instead of hardcoding the stored procedure name itself ?

I hope i explained myself properly.