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;
exec sp_XXX_posting_code_analysis @CurrentPeriodBegin = '01-Oct-2010', @CurrentPeriodEnd = '30-Sep-2011', @PreviousPeriodBegin = '01-Oct-2009', @PreviousPeriodEnd = '30-Sep-2010', @StartYear = '09'
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
Bookmarks