Hi there,
I have a list of tables like this:
January_2014
February_2014
March_2014
...
Is there away I can create union within VBA that will search for tables like the above and add them to a union query or append them to a master table?
Users will be importing a new table each month so I need the VBA to pick new month tables
Kindest regards
Max
I have a list of tables like this:
January_2014
February_2014
March_2014
...
Is there away I can create union within VBA that will search for tables like the above and add them to a union query or append them to a master table?
Users will be importing a new table each month so I need the VBA to pick new month tables
Kindest regards
Max