Word Automation and Memory

[Matthew W]

Hi
I'm trying to perform Word Automation through Access VBA and have some real
problems with speed. This occurs when finding and replacing codes for values
from the database. I think I've pinpointed the issue to the find and replace
routine. However, this works quickly when on one of our servers - I was
wondering whether memory had anything to do with this - in particular virtual
memory? A merge that takes 25 seconds on my 2GB RAM but 2096MB virtual memory
takes 2 seconds on a server with 6GB of virtual memory. However, my computer
is never stretched when looking at it via task manager. Could anyone shed any
light on how to speed up word automation (find and replace) or whether
increasing virtual memory could do this?

Thanks
Matt

 

[Cindy M.]

Hi Matt,

I'm trying to perform Word Automation through Access VBA and have some real
problems with speed. This occurs when finding and replacing codes for values
from the database. I think I've pinpointed the issue to the find and replace
routine. However, this works quickly when on one of our servers - I was
wondering whether memory had anything to do with this - in particular virtual
memory? A merge that takes 25 seconds on my 2GB RAM but 2096MB virtual memory
takes 2 seconds on a server with 6GB of virtual memory. However, my computer
is never stretched when looking at it via task manager. Could anyone shed any
light on how to speed up word automation (find and replace) or whether
increasing virtual memory could do this?

Find/Replace is notoriously inefficient. My recommendation would be to use an
alternative method for "merging" your data into Word. Hard to make any
recommendations along these lines, though, without knowing more about the
scenario. For example

1. Version(s) of Word involved

2. Single document (one Access record) or multiple records?

3. Who sets up the documents (IOW how much control do you have over the data
targets and how complex could the process of doing so be)?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail