Set oConn = CreateObject("ADODB.Connection")
Set oComm = CreateObject("ADODB.Command")
oConn.ConnectionString = sConnectionString
oComm.CommandText = "myStoredProc"
oComm.CommandType = 4 ' adStoredProc
oComm.Parameters("myParam") = "This"
oComm.ActiveConnection = oConn
Written from the top of my head. Your mileage may very. Check syntax carefully. Never run while carrying scissors by the handle. Always keep your barrel pointed downrange.
Set oRS = oComm.Execute
Have you hugged your backup today?