I just discovered this trick and it's very cool. Set up
your parameters in MS query using the brackets []. The
first time you return data to Excel, it will prompt you
for values.

After the query is in Excel, right-click in the query
range. You will see a Parameter choice on the menu.
Click on that, and it will give you the option to specify
a cell location for your parameters.

Diane
-----Original Message-----
I am trying to use MS query to return data from a SQL
Server Database
using an existing stored procedure.

How can I pass parameters to the sp from MS query? I'd
like to keep
the parameters in worksheet cells.

Thanks
.