Calling Procedures in other Projects

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

 

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

 

[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!!

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 >

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,

 

[keepITcool]

another tip for shared code...?

centralize individual eventhandlers by using the application object's
events, so you can monitor all workbooks in the running instance from 1
place..

see
http://www.excelforum.com/showthread.php?threadid=275605
be sure to follow link to chip's site.


have fun!

keepITcool

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