Hidden Word window

[Newbie]

Hello,

In Excel a VBA procedure loads a Word document and fills in some tables.
During this job, I need the Word document stays hidden. How can I do that?
Thanks in advance.

Newbie

 

[Doug Robbins - Word MVP]

See the article "How to speed up Word Automation by hiding the application"
at:

http://www.word.mvps.org/FAQs/InterDev/MakeAppInvisible.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Newbie]

Thanks, Doug!

See the article "How to speed up Word Automation by hiding the application"
at:

http://www.word.mvps.org/FAQs/InterDev/MakeAppInvisible.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Newbie]

Dough,
I tried the Word.Application.Visible = True
but without any success : the Word document still displays full screen while
the Excel VBA macro stops because it's waiting for an answer to its dialog
box which is hidden by the Word window.

The true mystery of the world is the visible, not the invisible. -- Oscar
Wilde

 

[Doug Robbins - Word MVP]

I think you would want to be using

Word.Application.Visible = False

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Klaus Linke]

I tried the Word.Application.Visible = True

Shouldn't it be .False?

I don't do it too often, and haven't used Application.Visible.

Instead, I use the parameter .Visible:=False when I open or create the
document:
Dim myDoc as Document
Set myDoc=Documents.Add or .Open(..., Visible:=False)

Klaus

 

[Newbie]

Thanks a lot Doug and Klaus!
Of course, I wanted to write : .False. (definitly, I need some vacations...
;-(
I'll try the .Open(..., Visible:=False)

Thanks again

 

[Newbie]

I confirm that the .Open(..., Visible:=False)
is working fine. Thanks a lot!

Newbie