Running a macro to run a macro
Posted on 2011-09-05
Having the following problem:
I have separate databases (all very similar in structure but disimilar data and all used by a different user). However I have to extract data from all five databases.
So my idea which I 've worked on a bit is :
I've run a make table query in each of the separate databases thereby creating a specific table in each of the databases.
I have then gone and created a separate program in Access and written a macro which imports all the separate five tables into this one database. And then run a query to join up all five table into one. So far so good.
I now have a separate program that can "stitch" together five tables into one but I am reliant that each separate user run their query to create the initial table.
Now I was wondering whether I could run a macro of some sort or possibly write some VBA code where I could initiate the creation of the initial tables from the New database and therefore not rely on the individual user to do so?