Word Automation - Eliminate Screen Flashing on Open...

[Wrangler36]

I am using automation to open three Word files from within Access. I would like the Word application to be invisible until the three files have been opened. They are each being opened in their own windows.

I am trying to eliminate the screen flashing that the user sees when the three Word files are opened consecutively. I thought the command "WA.Visible = False" would accomplish this, but I still see the three files being opened, along with the screen flashing.

Here is a smaple of the code I'm using:

Set WA = CreateObject("Word.Application")
WA.Visible = False

With WA
.Documents.Open strPath & "File1.doc"
some other code
End With

With WA
.Documents.Open strPath & "File2.doc"
some other code
End With

With WA
.Documents.Open strPath & "File3.doc"
some other code
End With

WA.Visible = False
Set WA =nothing


How can I make the Word application (for each of the three windows) invisible until all three files have been opened?

Thanks.

 

[JerryKlmns]

How about

WA.ScreenUpdating = False

 

[Wrangler36]

JerryKlmns,

I put the WA.Screenupdating=False command just before the .Documents.Open strPath & "File#.doc" line, but it had no effect - I still see the screens flash as the 3 files are opened.

Are there any other ideas???

 

[CautionMP]

When opening the documents did you try setting the [tt]Visible[/tt] property to [tt]False[/tt]?

...
Documents.Open strPath & "File1.doc", , , , , , , , , , , False
...

Then after all three files are open set the [tt]Visible[/tt] property to [tt]True[/tt].

CMP

(GMT-07:00) Mountain Time (US & Canada)