Running a remote macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way I can run a macro in one database from another? In other
words, I'm in Database A and want to run a macro in Database B. Thanks.
 
You can use reference from MDB1 to MDB2, so MDB1 will recognise all the
functions in MDB2.
Open MDB1, when you are in code (any where), select tools, reference. browse
and select MDB2.
You will notice that MDB1 recognise all the functions, but it wont recognise
forms, reports, macros etc, so if for example you want to run a macro in MDB2
From MDB1, create a function in MDB2 that run the macro, and then call that
function from MDB1
 
Back
Top