I have some vba code right now that uses an ifexist module (it checks to see if a file exists) if it does, it imports it. The files are all named Extra1 - Extra10, and are always in order. So if there are 3 files, they will be named Extra1, Extra2, and Extra3.
Here is my issue, I have a cross-tab query that uses a field from each of the Extra tables as a row heading. The problem is I have to manually go in and delete the extra tables from the query every time depening on how many Extra tables there are. And if there are more this week than last week I have to add them in.
I have 135 queries that run every week and I would like to streamline this. Any ideas?
Here is my issue, I have a cross-tab query that uses a field from each of the Extra tables as a row heading. The problem is I have to manually go in and delete the extra tables from the query every time depening on how many Extra tables there are. And if there are more this week than last week I have to add them in.
I have 135 queries that run every week and I would like to streamline this. Any ideas?