template maximum size

[Gil Carter]

Hi All,

An attached template I use almost constantly is nearly 5 MB in size. Does
the size make it more likely to throw an error? About twice a week I have
to reboot in the middle of the day to clear things. After rebooting, things
function fine. MS Word 2003, Windows XP, Sony Vaio laptop. I had the same
problem with Office 2000 and suspect it is more a hardware problem than MS
Word.

If size does create a problem, does reducing the size by moving half of the
code into an add-in template work better?

tia & Cheers,
Gil

 

[Jonathan West]

Hi All,

An attached template I use almost constantly is nearly 5 MB in size.
Does the size make it more likely to throw an error? About twice a week I
have to reboot in the middle of the day to clear things. After rebooting,
things function fine. MS Word 2003, Windows XP, Sony Vaio laptop. I had
the same problem with Office 2000 and suspect it is more a hardware
problem than MS Word.

If size does create a problem, does reducing the size by moving half of
the code into an add-in template work better?

It sounds like you are suffering a touch of template bloat, which can cause
these kinds of errors. Take a look here for a cure.

Combatting Template Bloat
http://www.word.mvps.org/FAQs/MacrosVBA/TemplateBloat.htm

 

[Gil Carter]

Thanks Jonathan,
I think I tried this 3-4 years ago and so, ... it's reminiscent.

The code cleaner comes up with a message on my Word 2003 that says
"programmatic access to Visual Basic Word project not trusted." and stops
there before getting off the ground. This is so even when template is not
"protected."

I've copied the modules, toolbars and UserForms. I'll play with it further.
I'm presently working on getting the keyboard shortcuts to copy over to the
new template. I have a few issues I am working on with the importing of the
autotexts.

Thanks for the pointers. I'll get back to the group if I am hitting blocks
I cannot get past.

Cheers,
Gil