I have 10 queries where I need to specify the year and month. To avoid entering this data 10 times, I created a user form to select the values from a combo box and creating a macro to run all queries. The problem I'm facing is that these queries no longer appear in the 'Data Connections' in Excel 2007. I have determined this is because there now no set value in the queries. My question is what is the best macro/link/table that I can create so that I can avoid having to input 10 values all the time, and how can I make sure I am able to connect to the queries through Excel?