S
SixSigmaGuy
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,
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,