Hi,

I am porting a report generator which is using Word for formatting the
reports using VBA.
I have a problem with a big document here - the document is about 1,100
pages, 5,5 MB. For generation it takes about 15 minutes on Word 97.

the destination platform I have to port it to is running Word XP. The macros
there are running much slower - the same report takes about two (!) hours
and the generated Document is about 33 MB (!).

I have looked on several news groups and found the normal things, like
turning off fast saves etc., but all options were already deactivated.
Deleting normal.dot and cutting and pasting the contents into a new document
did *not* make the size smaller.

I guess the size and runtime correlate somehow, so is there a way to keep
the document small while generating?

Thanks in advance for your help.

Regards,
Stefan

P.S: For private reply please write to
stefan.bindel.intern(at)msc-online.net

I use Application.Visible = False at the beginning. That should do it,
right?

I am only using Documents and Selection. I close the Documents at the end.
What exactly do you mean with destroying the objects? Are there any objects
created implicitly?

Not really, no.

Regards,
Stefan

1. Correct

2. Lets say you use a document object of your own:

Dim D as Document

at the end of your routine you should do a

Set D = Nothing

if you are only using the built in objects like ActiveDocument and
Selection this is unnecessary, otherwise all variables that hold any
object type should be explicitly cleared in this manner to force the
execution of their terminate event.

Steve Hudson

Word Heretic, Sydney, Australia
Tricky stuff with Word or words for you.

Products:   http://www.geocities.com/word_heretic/products.html
Spellbooks: 735 pages of dump left and dropping...

The VBA Beginner's Spellbook: For all VBA users.