VBA reference problem

[Tobias Schröer]

Hi folks,

I have two word template projects.
One is loaded globally from the autostart folder you can specify in the
word options. This one contains a toolbar button by which the user can
add a signature graphic file to the document and some basic methods
(like "take the current document, save it and do something with it").

The other is a document template with some form fields and a toolbar
button. When pressing the button, the form fields are read and one of
the global template's methods is invoked. To be able to cll the global
template's method, I need to reference that template. The global
template can be found on a network resource, like \\MyServer\Templates.

Everything works perfectly fine on my developing machine.
When a user now clicks the button on his machine, he gets a compiler
error message, that says that the global template project cannot be
found. When I check the references, I have an entry like "Missing:
~w????.tmp". Back on my developing machine, the reference now points to
the user temp folder and not to the network share anymore. Though,
everything still works fine.

How do I reference a template from a networkshare correctly? Merging the
global template's code to the second template is not an option. There is
a third, fourth, ... template as well (all with the same problems). And
I want to avoid the maintainance effords

Thanks for any suggestions,
Tobi

 

[nobody]

Trivial question: Does the user has the rights to the network share?
Alex.

 

[Tobias Schröer]

Trivial question: Does the user has the rights to the network share?
Alex.

Trivial answer: yes, he can open the template
As said, the tool bar button is available. And the user's groups hass
access rights on the share.

Meanwhile I did some investigation by my self. What I have found, is
that if I remove the reference from the template project and load the
reference explicitly before invoking any of its methods, it works!

I wonder if I should remove the reference after the marco has run.
Suppose User A creates a new document on the doc template and runs the
macro (which adds the reference). The user A saves the document. Now
user B opens the document and wants to run the macro again. I need to
test this, but I fear I will be facing the same problem again, if the
reference is set.