Cindy

Thank you again and bear with me for my ignorance.

What I am trying to achieve is to place tick boxes in a document that is
automatically generated by an Access VBA Apps. I shall try to elaborate:

1. I create a template on my local machine that contains the two macros and
the two Autotext (because Autotext cannot be carried in the document).

2. I create a document on my local machine that is based on the above
template (using FileNew).

3. I copy the template somewhere on the server and save it as a template,
which saves it in the common template directory.

4. MyAccess Apps creates new documents by copying the document save in 2.
above and add some additional data from the Apps to the new document.

5. The newly created document by my Apps resides on the server and can be
accessed by users from anywhere.

4. Users can edit the document before printing, including using the tick
boxes.

That is when the problem starts. When they double click the box nothing
happens i.e the macro is not working.

Would you have had the macros in the base document rather than in the
template?
What is the proper way to save the template to make it global; put it
anywhere on the server and put the path in the workgroup template or is
saving as a .dot enough for it to be seen by others.

I was hoping that the newly created document would find the template on the
server if it can't find it anywhere else.

Thanks again
george






"Cindy M -WordMVP-" wrote:

Hi ?B?R2VvcmdlTWFy?=,

This is causing me some problems.

A lot of your problems sound really strange to me. Macros shouldn't be getting
"lost" from a file, if they're in the file (document). It may be unfair to you,
but I have to assume you're doing something wrong; what isn't apparent from the
description, however.

A template in a shared network location. Set that folder for the users'
"Workgroup templates" option (Tools/options/file locations or, better, a system
policy to make the setting in the Registry). The template will always be
available via File/New.

Other than that, if a template is located in a folder with all the necessary
permissions, any document should be able to "see" it, if it has been properly
attached to the template (Tools/Templates and Addins). If the file path to a
template could be changing, it helps to list that location in the environment's
PATH setting.

Firstly, I use FileCopy because I am copying from a base document
(basefilename) that contains the bulk of the data and the layout, to a new
document (newfilename) I then customise the document using
documents.add(newfilename)

The base document and its associated template are created on my development
computer. I then put the document and the template on the customer's server.
I did not use an add-in. On the customer's server, I saved the template as a
template and that only created a local template.(and the macros were missing.
I had to copy them in again)

Here is where I am having the problem. On the customer's server, I can't
get the document to see the template. I have managed to get it to work on
one local machine, by almost rebuilding the template on that local machine,
but not across the network.

The question is, what is the best way to transfer the template from my
development machine to the customer's server and how do I get the users to
see the common template across the network?


Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)