I'm not sure if I'm using the best key words but hopefully the below explains it better:
My Access database queries originally had values for fiscal year and month-- "2010" and month "Feb". I created a user form with a drop down menu that one can select the fiscal year and month from, and now the same queries that used to show up in Excel through the Data Ribbon-->Connections-->Add process no longer show. Only the tables do. I have at least 10 queries like this and would really like Excel to show them! What is the solution to this?
Because I have now created a macro that runs through all the queries taking the input from the user form, it would be extremely counterproductive to reverse it back to putting in the fiscal year and month manually. The only thing I can think of is to copy and paste the data in my Excel sheets from the Access queries but this is in no way efficient either. Any suggestions welcome!