Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Subject: Calling Procedures in other Projects
Is there anyway I can call procedures in other Excel VBA projects from my existing Excel VBA project without having to export and import the code? VBA help gives an example of doing this under the topic of calling procedures with the same name in different projects, but I get an "Object Required" error when I try to duplicate the example. The example goes something like: Sub Main() [MyOtherProject.XLS].[SomeModule].MyProcedure End Sub I've tried seeing if I could do it somehow with the Application.VBE, VBProjects, VBComponenents, CodeModule objects, but no luck. Seems that's only for modifying the code; not running it. Sure would appreciate any help if anyone has some suggestions. Thanks, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA Sub procedures | Excel Programming | |||
Calling procedures in .xla projects | Excel Programming | |||
Calling Procedures from another excel sheet by passing objects | Excel Programming | |||
Calling Procedures | Excel Programming | |||
How to become a better programmer, post college. More projects or less projects. | Excel Programming |