Adding excel paramaters to a Stored Procedure

[CatIsoSio Sky]

Hi
Im using a stored procedure to call on an sql view from within an excel 2007 file. So in connection properties in Command Text: the following is available to me;

Please Login or Register  to view this content.

the commany type is SQL


Rather than i having to go into the command text every time to change the date paramaters above i would prefer to create links to cells in the excel file itself (as you could with Microsoft query) and in turn input the dates there. I tried inputting [Paramater1] instead for one of the dates but it returned an error and did not as id hoped bring me into and screen that would faciliate i adding the paramater information.

Any help would be much appreciated