Normal.dot Growing in Size

[Trevor]

I have created a Macro to run at startup, so I have put the template in the
Word 2003 startup folder and have named the macro AutoExec, everything is
good, but I notice the Normal.dot continiously grows in size at a rapid rate.
All the VBA does is create a menu which is defnied as temporary and the
second time it runs it checks for the menu and creates it if its not already
there.

Why would the Normal.dot seem to cache these functions (searching inside the
Normal.dot I can find many copies of the menu not the code), and how can I
stop this from happening?

Thanks in advance.

 

[Graham Mayor]

Why don't you just put the menu in the add-in (or document template that
requires it) and forget the macro?

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Graham Mayor]

From your description earlier you have created an add-in template which
seeks to add a menu, if not present, with vba. If you put the menu in the
add-in, it will always be present whenever the add-in is loaded, so the part
of the code that checks for it is superfluous. You don't have to make things
more complicated than they need to be, just because you can.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>