call stored procedure from Excel 2007

[osoful]

I need to call a stored procedure from Excel that will return the result sets into my work sheet. My stored proc consists of 2 SELECT statements where the first statement always returns on result set and the second statements returns multiple rows as a result set.
I need a button or user form maybe in which I can enter one parameter to pass to the stored procedure.
I'm an SQL guy but my Excel/VB are somewhat poor . Has anybody done something like this before?
Thanks

[Azureus123]

1-create connection to data
- Data tab=> Get External Data=>From Other Sources=>From SQL Server=>Configure, pick any table
2-modify Import Data properties
-Import Data screen=> Properties=>Definition tab=>Command Type - Change Command Type: to SQL
3-Put exec statement in Command Text: ie exec spTest @date='1/1/2010'

Question - Does anyone know how to pass sp parameter (@date) from spread sheet for easier user entry?