Microsoft query controls

Hi,

I'm not sure if I'm posting this in the right place, but here goes.

I'm extracting information from a stock system into Excel 2010 and each week have to go into the query and change the week number.

Is there a way that I can include some controls on my excel sheet to do this?

I want to be able to have a box that shows the current week number, a space to input the new one and a button to change this in the SQL and run the query.

Any help is appreciated.

you can use parameters in queries: http://www.mrexcel.com/forum/excel-q...ter-query.html