B
BGC
The VBA routine that I've created runs much more slowly when MS Word is
already open. If it's NOT open, then the routine opens up Word and runs
pretty quickly (about 10 seconds). But if Word is already open, then it's
very slow, taking about 5 minutes to finish the routine.
This problem only happens with Word 2002, to the best of my knowledge. With
Word 97, for example, the routine runs just as fast whether or not Word is
open.
Does anyone have any idea why this is happening, and what I can do to speed
up the routine when Word is already open?
FYI, the application starts in Excel where the user creates a certain
product configuration. Once they've created the configuration, the user
invokes a VBA routine (via a button) that opens up MS Word and searches for
sections to pull out of a Word-based "library" of subdocuments so that a
proposal (based on the selected subdocuments) can be assembled.
already open. If it's NOT open, then the routine opens up Word and runs
pretty quickly (about 10 seconds). But if Word is already open, then it's
very slow, taking about 5 minutes to finish the routine.
This problem only happens with Word 2002, to the best of my knowledge. With
Word 97, for example, the routine runs just as fast whether or not Word is
open.
Does anyone have any idea why this is happening, and what I can do to speed
up the routine when Word is already open?
FYI, the application starts in Excel where the user creates a certain
product configuration. Once they've created the configuration, the user
invokes a VBA routine (via a button) that opens up MS Word and searches for
sections to pull out of a Word-based "library" of subdocuments so that a
proposal (based on the selected subdocuments) can be assembled.