I am trying to write a macro that opens another Access Database, launches a macro within that database, and then close the second database when it's macro is done. I know this could not be done in Access 97, but can be done in 2000. In a nutshell, I am attempting to create a macro that...
1)Exports a table from mdb1 to another folder where mdb2 resides (I know how to do this).
2)Opens mdb2 and launches a macro on mdb2 (all behind the scences w/o the user seeing it).
3) When the macro on mdb2 has finished, the mdb2 closes and reactivates mdb1.
I haven't learned code or VB, so bear in mind that I am a newbie.....
Any help would be GREATLY appreciated!!!!
1)Exports a table from mdb1 to another folder where mdb2 resides (I know how to do this).
2)Opens mdb2 and launches a macro on mdb2 (all behind the scences w/o the user seeing it).
3) When the macro on mdb2 has finished, the mdb2 closes and reactivates mdb1.
I haven't learned code or VB, so bear in mind that I am a newbie.....
Any help would be GREATLY appreciated!!!!
