Issuing macro in workbook from separate workbook

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

Guest

Hi,
Can a macro be issued from another macro in another workbook?
i have a macro which copies cell contents, opens another workbook and looks
in range for a matching number. i can get as far as using one macro to copy
the selection and open the workbook, and another macro to select the sheet
required, match the number and paste the contents. However, i cannot issue
the other workbook macro from my button. i need to be able to start the other
macro with a command or correct input to start it.
my thought was
[personal.xls]workcell ( but this doesn't work )

Kind Regards,

Nigel
 
Nigel,

Try something like


Application.Run "myBook.xls!myMacro()"

or if it has an arguement

Application.Run "myBook.xls!myMacro", "hello you"
 
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

how to prevent macros in Personal.xls appearing in other workbook 3
Macro not finishing due to loading workbook 7
saving macro from workbook to Personal Macro Workbook 1
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
Macro to push data to another workbook 0
Copying macros to another workbook 2
How to copy a range of cells and paste into a new workbook in differentcolumns 3
Move/Copy Worksheet with Macros 2

Back
Top