SQL Server: procedimiento almacenado

[Nch]

Desde VBasic:

Dim cmd As New Command
Dim rs as New Recordset

With cmd
.ActiveConnection = TuConexion
.CommandText = "Execute TuProc ?,?"
.Parameters(0).Value = TuParametro1
.Parameters(1).Value = TuParametro2
End With

Set rs = cmd.Execute 'Si el proc
'devuelve un cursor

Ojala te sirva