Update Word document in background

F

Fabien

Hello,

I have big performance problems with a VBA for Word program.
In this program, I copy, add (or delete) and edit rows from one table to an
other, many times.
The problem is that Word update the screen at every modification and that's
takes time !
Does someone know if it is possible to "bufferise" the modifications of the
document, then, when all is done, update the screen with the modified
document ?

Thank you for your help.
 
H

Helmut Weber

Hi Fabien,

Application.ScreenUpdating = False

still faster
Application.WindowState = wdWindowStateMinimize
....
Application.WindowState = wdWindowStateMaximize
which may confuse users

still faster, probably

using ranges insted of selection,
which beginners usually aren't aware of.

Or using all together.

--
Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Win XP, Office 2003
"red.sys" & Chr$(64) & "t-online.de"
 
F

Fabien

Helmut said:
Application.ScreenUpdating = False

still faster
Application.WindowState = wdWindowStateMinimize
...
Application.WindowState = wdWindowStateMaximize
which may confuse users

still faster, probably

using ranges insted of selection,
which beginners usually aren't aware of.

Or using all together.

Thanky you very, very much Helmut !
I will try that as soon as possible.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top