Mark,
To create a comma delimited result set
1. In Query Analyzer or SSMS click Tools>Options>Query Results and change
the
Default Destination for Results to "Results to File"
2. Execute the procedure passing the parameters and specify the file to
save it to.
By default the file extension is .rpt. You can leave the default or
change
it to .txt to reduce confusion if need be.
3. Open Excel and click File>Open and choose file type of All(*.*)
4. Navigate to the result file and click Open
5. Page 1 of the Wizard leave default settings click Next
6. Page 2 uncheck Tab and check Comma in the Delmited Group Box
7. Page 3 you can specify the column data types and click Finish

This allows you to import the results to excel from a comma delimited file,
but does not provide an end user interface. Excel has the ability to connect
to outside data sources, but for SQL is limited to Views and Tables. If the
query allows you can create a view and then have the user use the WHERE
clause to take the place of the parameters.

You could also use osql and a batch file or VB script to provide the ability
for the end user to specify parameters.

1. Have the end user create a text file and enter into it only the
parameters
separated by commas. Save the file with a specific name and location.
2. The batch file/vb script will create an input file using the user's
file to create an
EXECUTE statement and placing the parameters into the statementd from
the
users text document.
3. Use an output file to capture the result set and open the output file
in Excel as
outlined above.

Good luck and let me know if this helps.

[quoted text, click to view]