View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SixSigmaGuy SixSigmaGuy is offline
external usenet poster
 
Posts: 9
Default Calling Procedures in other Projects

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,