bringing Word in fornt of Excel

[Jacko_B]

I am writing an Excel macro in VBA that uses a data array to post the array contents in a Word Table cells. I am very new to Word VBA.

I start in Excel, and when I open the Word document via the macro, I want to activate this Word document and bring it to the front of the screeen, so that I can see what is going on. At the moment the Excel spreadsheet fills the screen

Can anyone please advise the instruction to do this?

regards,
Jacko

[Andy Pope]

Maybe you can use this



Application.ActivateMicrosoftApp xlMicrosoftWord

[pacfleck]

You should have created this WORD document using "set". So, to the variable you are using to refer to the word application use (I called it "yourvariable"):
"yourvariable.visible = true"
"yourvariable.activate"