Article contributed by Daryl Lucas Many people know they can speed execution of Word Automation by turning off screen updating: Word. Screen Updating = False Many do not know, however, that they can get an even greater speed boost by hiding the application altogether.

pplication screenupdating false-60

Before I start, I will admit I posted this in a forum that helps me a lot with another Office product, but as of this post they were not able to shed any light on this issue.

I created the code below which does what it was written for, BUT the screen updates whilst it runs. Echo as a solution, but that is not recognised in Word 2007?

This can result in you not knowing whether the process is still running, but the easy answer to that is to use a progress indicator bar.

Screen Updating = True Exit Sub Err_Exit: Msg Box Err. Number End Sub If you don't want to have the flicker as the documents are opened, open the documents invisibly.

Paste And Format (wd List Combine With Existing List) ' The above inserts a line which creates a second page, so delete a line after Selection. Delete Unit:=wd Character, Count:=1 Active Document. Close Save Changes:=wd Save Changes Next Set doc To Open = Nothing: Set Doc = Nothing ' Switch Screen updates back on Application.

This can mean that what should take a matter of 1 to 3 seconds, often takes a lot longer.

Word does not need to display itself in order to run.

In the above code, you could omit the lines that create and use the Word.

Application object and replace them with invisibility lines: Notice that you want to put the Word. Visible = True line in an error-handler or in a spot where you know it will be run if something goes awry. (If you do get stuck with an invisible Word in the middle of a crash, you can launch the Task Manager and kill the WINWORD.

EXE process.) How much of a difference does invisibility make?

You can verify this by launching Word the old-fashioned way and opening File1 at the bottom of the File menu after running the sample code.