Word 2000 Template and VBA Script Deployment

  • Thread starter Thread starter Allan Heseman
  • Start date Start date
A

Allan Heseman

I develop forms in Word 2000 for the Missouri State
Highway Patrol, and need a way to deploy Form Templates
with scripts to approximately 3000 employees using
templates from two different storage locations ("C:\MSHP
Forms " and a Network drive "\\srvrghq\MSHP Forms"), these
employees also need to share the documents they create
from different template storage locations with each other.

We have officers using portable computers in cars that
have templates loaded on their local C:\ drive, because
they are not always connected to the network. The office
personnel using desktop computers access templates from
the network because they are connected all the time.

Unless I am doing something wrong, when a document is
created from a template in Word 2000, none of the scripts
transfer from the template to the child document. Instead,
a reference to the template is placed in the VBA Project.
When a script is called in the document, it is accessed
from the referenced template.

Here's the problem: When an officer in a car creates a
document from a template stored on C:\, the document has a
reference to the template on C:\. When that document is
sent to the office, the clerks can open and read the
document, but none of the scripts work because they do not
have the template stored on their C:\ drive; their
templates are on the network. The problem exists in
reverse when someone in the office originates a document
and sends it out to an officer in the field. I can copy
templates (there will be around 700) to everyone's C:\
drive, but that causes a tremendous amount of overhead and
is very inefficient, so I'd prefer another way.

I created a script using the "Application.OrganizerCopy"
method to copy all the scripts from the template to the
new document, thus making every document a self-contained
uint; however, VirusScan sees this as a W97M/Generic virus
and deletes all the scripts from the document and template.

Is there a way to deploy the Word 2000 templates without
copying them all to C:\ on all 3000 computers?
Should I use something other than templates to deploy
these forms?
Am I developing the templates wrong?
Is there a way to make the documents (.doc's) self-
contained units with all the scripts without tripping
virus scanning software?
I'll be glad to send you examples or whatever you need.
I've been fighting this for about 3 years and am at wits
end.
NOTE: Excel automatically copies all scripts from
templates to new workbooks. Is there a setting that will
allow or make Word do the same thing?
Thank you
 
When a patrolman sends a file created from his template on his "C" drive to
someone in the office, they don't have the template located in the same
place so it can't find everything. The office person can click "Tools",
"Templates and add-ins". Click the "Attach" button and browse to the
network location of the template and select it, then everything should be
fine.
 
Back
Top