PDA

View Full Version : Letting others use routines I've written


cc_brewster
01-11-2005, 05:51 PM
I have written a program for others to use, but I don't know how to make it work on their machines. I developed the code in Normal.dot and copied the modules to a separate template file (using Project View). I put the new template on a network drive. As suggested in another forum, someone wanting to run the program entered the template name in the Word Startup directory. But when we attach the template to a document and do Tools/Macros/Macro, the macro list is blank, even when I specify the name of the template in the "Macro In" box. My guess is that my way of creating the template was wrong, but other approaches I tried ran into other problems. Any suggestions appreciated.

Christopher Brewster
Lockheed Martin

lynnnow
01-12-2005, 04:01 PM
Hi,

Another option you would like to try is to rename the Normal.dot that you created to a new name and place this file on the network. Try the steps you have already used (excluding the Project View stuff) and see if it works.

Post back if any doubts.

HTH

Lynx

cc_brewster
01-12-2005, 05:00 PM
I got it working. This was a case when I did all the right things but not together: first I got A right, next time I got B right, but I needed to do A and B together. When I exported my modules to a new template *and* deleted them from normal.dot *and* put the template in the other user's Word Startup, it finally worked. Thanks for the help.

Christopher Brewster
Lockheed Martin

cc_brewster
01-12-2005, 05:16 PM
My previous post was premature. Now I remember how I got in the fix: when I do all that I described, the resulting project is unviewable. I was trying to make a template separate from normal.dot that would allow me to develop in it. I can't think of any way to make it "cleaner" than the way I've done it. Any more suggestions? Thanks.

Christopher Brewster
Lockheed Martin

cc_brewster
01-12-2005, 06:03 PM
To answer my own question: I needed to do these things:

- copy the modules from Normal.dot into my new template
- delete the same modules from Normal.dot
- leave the new template in my Templates directory
- put the new template in the other user's Word Startup directory

Now I can develop within the new template, and the other guy can use the macros without attaching to each doc. It's all so clear now!

Christopher Brewster
Lockhee Martin