If your just returning a value you don't need the recordset.
Simply define it as a second parameter. The choice to use
adParamOutput vs adParamReturnValue depends upon how the stored procedure is written.

If you use adParamOutput then the value must be defined in the parameter list at the beginning of the stored procedure:

Example:
Param integer OUTPUT

The OUTPUT keyword is required to let SQL know that it is an output parameter.

If you use adParamReturnValue then the value will be the value that is returned by the "Return" statement in your stored procedure:

Example:
Return (100)

Note: you can only return intger using the return statement

If you use either of the methods you only have to execute the ado command object.

Hope this helps