Template Bloat

[Wes from Scottsdale]

I've been developing a template for my office. Everytime I save the .dot
file, the file size increases. Today I went into the VBA and deleted a
single line of code and the file grew from 66kb to 75 kb. The template has
one simple form (< 5 controls) and about 80 lines of vba.

First, why is this happening. Second, is there a way to force Word to
recompress/compile the template back down to its normal size? The template
was about 39kb when I first added the form/code.

Thanks.

 

[finalword]

Yes...Template bloat is a problem! I'm working in Word 2003 and I'm always
trying to keep the template file size down.

One thing that helps me is the way I save the file. I don't actually save
it. Once I've made my changes, I make sure to close out of the VBA editor.
Then I go to a blank line in the template, hit enter once and then backspace
it out. Then I close the file via File | Close and let Word ask me if I want
to save the changes. Click yes to save the changes. I know it sounds wacky,
but it works for me.

Give it a try and see if it helps.

 

[Jay Freedman]

I've been developing a template for my office. Everytime I save the
.dot file, the file size increases. Today I went into the VBA and
deleted a single line of code and the file grew from 66kb to 75 kb.
The template has one simple form (< 5 controls) and about 80 lines of
vba.

First, why is this happening. Second, is there a way to force Word to
recompress/compile the template back down to its normal size? The
template was about 39kb when I first added the form/code.

Thanks.

Try http://www.word.mvps.org/FAQs/MacrosVBA/TemplateBloat.htm.

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.