Open and activate the JuliePersonal project. In VBE, go to Tools >
References. Check the box alongside Julie.
Then in your code you can use: Julie.[ModuleName].CreateReport
[ModuleName] is the name of the code module containing the CreateReport
function.
> How do I write code to access and run a procedure in a module in another
> project. When the project template is opened in the Visual Basic Editor,
[quoted text clipped - 16 lines]
>
> However, I get a run-time error 424: Object required.
singeredel - 14 Feb 2005 17:29 GMT
I am trying to access the Julie project from the Normal template project. I
previously tried creating a reference to Julie in the Normal project, but I
get an error that "Cyclic reference of projects is not allowed." I have a
reference to Normal in the Julie project to access a module in the Normal
project from the Julie project. Now I need the reverse to happen -- to be
able to access a module in Normal from Julie.
> Open and activate the JuliePersonal project. In VBE, go to Tools >
> References. Check the box alongside Julie.
[quoted text clipped - 24 lines]
> >
> > However, I get a run-time error 424: Object required.
singeredel - 14 Feb 2005 17:31 GMT
Sorry, my last sentence was wrong -- I need to now access the Julie project
from the Normal project.
Thx...
> Open and activate the JuliePersonal project. In VBE, go to Tools >
> References. Check the box alongside Julie.
[quoted text clipped - 24 lines]
> >
> > However, I get a run-time error 424: Object required.
This might not apply directly, but I thought these examples I wrote up for
another post might help you out:
To access "macros" in an add-in (global) template, you do not need to add a
reference
to it for the current document/project. The following are equivalent:
### Example 1 ###
' MyProject.ThisDocument has had a reference added to the template
Macros.dot. In this case, Macros.dot does not need to be loaded as an add-in
(global) template.
Sub Test
MacrosProjectName.ModuleName.PublicRoutineName x, y, z ' You don't
really need to include .ModuleName, but you can if you want.
End Sub
### Example 2 ###
' Macros.dot is loaded as an add-in (global) template, either by the user
from TOOLS | TEMPLATES AND ADD-INS, by code, or by being in the STARTUP
folder.
Sub Test
Application.Run "PublicRoutineName", x, y, z ' Application.Run in
Word 2000 or later will return the return value from the routine.
End Sub
### Example 3 ###
' The document has it's attached template set to Macros.dot
Sub Test
MacrosProjectName.ModuleName.PublicRoutineName x, y, z ' You don't
really need to include .ModuleName, but you can if you want.
End Sub
####

Signature
Tom Winter
tom@nospam.amosfivesix.com
> How do I write code to access and run a procedure in a module in another
> project. When the project template is opened in the Visual Basic Editor,
[quoted text clipped - 16 lines]
>
> However, I get a run-time error 424: Object required.
singeredel - 15 Feb 2005 18:31 GMT
Thank you so much for your reply. I am either not understanding what you have
written or something else is going on. I have tried the following code:
AddIns("C:\Julie-Personal\Word Templates\Master
Template\JuliePersonal.dot").Installed = True
Application.Run MacroName:="Julie.Create_Julie_Report.Create_Julie_Report"
(I have also tried: Julie.Create_Julie_Report.Create_Julie_Report and just
plain Julie.Create_Julie_Report)
I have installed the template "JuliePersonal.dot" as per above. I am trying
to run the procedure listed above from the Normal project but I am getting a
run-time error '-2147352573(8002003)" indicating "unable to run specified
macro" or "Object required."
I have a reference to "Normal" in my "Julie" project because I also need to
access a module in the Nomal template when using the "Julie" project and it
would not run that procedure until I added a reference to Normal.
If the "Julie" template is installed, why wouldn't everything in that
template be available from any project? Is there some place where you have to
indicate that the module is "Public?"
Thanks!
> This might not apply directly, but I thought these examples I wrote up for
> another post might help you out:
[quoted text clipped - 62 lines]
> >
> > However, I get a run-time error 424: Object required.