To execute a SQL stored procedure from the VBA code in MSAccess

Hi all,
I have MSAccess as my front end and SQL server 2005 as back end. From the front end MSAccess VBA code, I want to execute a stored procedure which is present in the SQL Server databse.
The stored procedure accepts 8 parameters and returns 1 result.
Kindly guide me to execute the stored procedure and capture the result in the front end VBA code.
Thanks in advance.
...