either
set a reference to the other project.
or
use application.run


also it may be wise to check that the function is exposed and
not private to the project or module.

easiest checked WITH a reference.
activate caller (not called) project
then open object browser and select the vbaprojectname for the called
project.

it may be handy to give your vbaprojects unique recognisable names.
iso VBAProject




keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"SixSigmaGuy" wrote :

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,