| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Referencing .Net Remoting Services project in MS Excel Macro | Excel Discussion (Misc queries) | |||
| can vba import code to vba project ? | Excel Programming | |||
| Removing all code from a Project | Excel Programming | |||
| unlock project with VBA code | Excel Programming | |||
| Discussion: VBA Project Code Protection | Excel Programming | |||
![Robert[_16_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
