Printable View
My colleague and I each use a global template to store macros for use in editing/formatting word documents.
We are unable however to call each other's subroutines even when both templates are loaded.
Am I attempting the impossible? Or is there an easy solution staring me in the face?
Are you saying you have a "Normal.dot" file on a shared or network drive and both of you have changed the "File Location" for templates to that dive (and it still doesn't work)?
no
we've both got separate .dot files (apart from normal.dot) which contain our macros.
they both get loaded from the startup dir when word begins
the problem being that they don't know of each other's existence, thus we cannot call each others routines, which is frustrating
If you load a .dot file or any word document, access to the macro subroutines exist as long as they are "Public" subs.
I'm guessing you pointed to it's location as a template folder location and are not manually opening it?
I think the easist thing to do is just to manually open that file whenever it's updated or something and copy the macros in it over to your own normal.dot file.
All you have to do is :
Open Word
Open the other guys template .dot file manually
Go to: "Tools/Macros/Macros"
Select "Organize"
Select the other guys '.dot' file in the left window and your own normal.dot file in the right window.
Then just click "copy".
Sorry, may not have explained it quite right...
We both develop macros for a team to use. We each handle different areas of these macros - one to do with editing, the other with tracking - but there is some overlap. For simplicity of development we each work on a different template, then the two .dot files are placed in each users startup folder - so loaded with word, and uneditable by the user.
The problem we have is the overlap - there are times when one of us would like to call a sub or use a function in the others macros. There does not seem to be any way to call anything from a startup-loaded sub - the user can run subs in it, and view what subs are in it, but another project cannot.
Sorry for not being clear, and thanks for the help so far.