Make window open in front after running Macro (MS WORD)

[richiwatts]

I have a Macro that works like a document wizard. When the wizard has finished it open up a template with all the fields from the wizard placed in it.

The problem is that the new document opens and I can see it in the task bar but it doesn't open on the screen straight away. I have to press the task bar once and then it minimises and then again to open it.

How to I make it open on top after the wizard has completed?

Many thanks
Richi

 

[Bowers74]

Windows("NewDocument.doc&quot.Activate



Peace!

Mike

Never say Never!!!
Nothing is impossible!!!

 

[richiwatts]

Sorry, I forgot to mention I am a total beginner

Where abouts should it go?

Richi

 

[Bowers74]

Enter it before the End Sub part of your macro. The NewDocumrnt.doc needs to be changed to the name of your file.

I hope this helps!



Peace!

Mike

Never say Never!!!
Nothing is impossible!!!

 

[richiwatts]

Thanks, but everytime I run the wizard it creates a new document. So, if I run the wizard 3 times it names them like ths:

document1.doc
document2.doc
document3.com

So how can I replace NewDocumrnt.doc with a file name? Or am I misunderstanding something. Sorry if I am...

Thanks
Richi

 

[richiwatts]

Thanks, but everytime I run the wizard it creates a new document. So, if I run the wizard 3 times it names them like ths:

document1.doc
document2.doc
document3.doc

So how can I replace NewDocumrnt.doc with a file name? Or am I misunderstanding something. Sorry if I am...

Thanks
Richi