Calling excel macro not located in that workbook.

C

cr113

Can I call an excel macro programmatically from another workbook in
Excel 2003?

For example suppose I have 2 workbooks, book1.xls and book2.xls:


book1.xls
module1
macro1

book2.xls
module2
macro2

How would I call book2.module2.macro2 from book1.module1.macro1?
 
R

Ron de Bruin

Hi cr113

You can use Application.run

Application.Run "YourFile.xls!YourMacro"
 

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

Subject out of range 3
Application.run and ByRef arguments 7
Automatically Excuting a Macro in a different workbook ? 10
Help with activating window from Application.GetOpenFilename 4
VBA to open a shortcut to a workbook 3
xlfTextRef from another workbook 1
How to Refer to Another Excel Workbook 1
Macro to compare, find match and copy between workbooks 6

Top