VBA scripts disappear from Normal.dot

[Jo Gjessing]

Hi all,

I've created a collection of template files for Word including a Normal.dot
file with a few short VBA scripts. I use robocopy.exe to copy the template
files to all my users' xp computers. When the files are copied, however, all
the scripts have disappeared from the Normal.dot file at my users' computers
- and sometimes from the file they were copied from as well. Can you imagine
why and what I have to do? If you have any ideas please let me know.

Thank you very much in advance.

Jo

 

[Lene Fredborg]

I don’t know robocopy.exe, but normally, macros to be distributed to others
should not be stored in Normal.dot. Normally, you should instead create a
separate template and store the macros in that template. You can then
distribute the template to all relevant users. When stored in Word’s Startup
folder on the individual user’s PC, the template will work as a global
template and the macros will be available to all documents.

See:
http://www.word.mvps.org/FAQs/MacrosVBA/DistributeMacros.htm

--
Regards
Lene Fredborg - Microsoft MVP (Word)
DocTools - Denmark
www.thedoctools.com
Document automation - add-ins, macros and templates for Microsoft Word

 

[Cindy M.]

Hi Jo,

I've created a collection of template files for Word including a Normal.dot
file with a few short VBA scripts. I use robocopy.exe to copy the template
files to all my users' xp computers. When the files are copied, however, all
the scripts have disappeared from the Normal.dot file at my users' computers
- and sometimes from the file they were copied from as well. Can you imagine
why and what I have to do? If you have any ideas please let me know.

My first thought would be some kind of anti-virus software that's stripping the
macros from the files.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
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