MS Query to read data from SQL server stored procedure
 

I have a spreadsheet which reads data from SQL server stored procedure result
set. It works if I do not need pass parameter to the stored procedure through
ODBC.
I would like to pass paramter to the stored procedure.

For exmaple:

MyProc @Param1 = '1111'

I wanted to pass Param1 to MyProc from sheet1.A1.

Is it possible to do the work?

Any information is greate appreciated