Calling Procedures in other Projects

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,
 
K

keepITcool

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

SixSigmaGuy

God, that was so easy. Thank you. I used the reference method. Geezz, I
just failed to consider the obvious. Too bad they didn't mention that in
the code sample I was going by.

This allows me to have a shared code project so I don't have to make copies
in every project that all end up getting out of sync over time.

Thanks a lot!!


keepITcool said:
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 said:
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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top