Re: Why word files with some VBA code get bigger and bigger over time?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


"Harvey" <Harvey@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:59E69668-A241-4F5D-AD3A-5EC846A7A687@xxxxxxxxxxxxxxxx
I have a macrobbok with over 50 procedures somewhere in our network and
users
use it to create standard documents. when they create a document using the
macrobook they save it somewhere in the network and next time they need
the
document they just modify some minor data or charts or add or remove some
text (using VBA code) and save it as a different version number. I noticed
after while the file gets so big does anyone know why is the reason ? Just
as
an example I was checking a document today that was version 26 with 76
pages
it was 13MB I used the macrobook to create a new book based on that book
(macrobok has a procedure to trasfer all data from a book to a new book)
and
I end up with only 1MB document which is identical to the version 26!
thanks :)

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

Mind you, a bloat of that size is unlikely all to be down to bloat in the
VBA project. I suspect that there is some other cause as well - e.g. saving
multiple versions in the file, Track Changes being on, or something like
that.


--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup


.