Referencing Code from another project
 

An Excel application containing modules creates another
workbook. At this point, the application looks like this:

vbaproject(aaa)
module1
module2

vbaproject(bbb)
sheet1
sheet2

From sheet1 in project bbb, I wish to call some code
contained in Module 1 of project aaa. How do I do this?

Referencing Code from another project
 

Application.Run "aaa.xls!MySubName"

--

Vasant



"Robert" wrote in message
...
An Excel application containing modules creates another
workbook. At this point, the application looks like this:

vbaproject(aaa)
module1
module2

vbaproject(bbb)
sheet1
sheet2

From sheet1 in project bbb, I wish to call some code
contained in Module 1 of project aaa. How do I do this?