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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calling Access 'form' from other applications 0
Run Macro If Cell have "x" value 0
switchboard not working after running a macro 4
What are the steps to fix damaged MDF files in SQL Server? 0
Pasting cell contents into a macro 1
error 2950 1
Run a macro from another database 6
VBA Excel - Select a value from one cell in Excel to update a SQL table 1

Back
Top