Maximize programs called from Userform

Hi,
I have a fairly complex Userform that transfers data to Word via the Word Bookmarks. This runs great, perfect actually... my only issue is that once the Word document is generated from the Userform, it stays minimized on the taskbar... is there a way via VBA to make this Word Document full sized so the end user does not have to click on it in the taskbar to see it?
Hope that makes sense...

Generally, a bit of code such as the following pulls up the Word document. (In this case, I'm assuming that the variable for the Word object is oWord. Change it to suit).

Please Login or Register  to view this content.

Let me know if this works

Originally Posted by BigBas

Generally, a bit of code such as the following pulls up the Word document. (In this case, I'm assuming that the variable for the Word object is oWord. Change it to suit).

Please Login or Register  to view this content.

Let me know if this works

Thanks BigBas but this is giving me a run time error '438' Object doesn't support this property or method

How are you creating/referencing the Word object? Can you post some of your code?

I just created a quick mock-up example, and using the code I pasted above worked for me.

BigBas,
I am a fool, I did not explain this right.. the Word doc actually does come up but is obscured behind the Userform... so I tried a me.hide then put the code snippet in to launch the word document followed by a me.visible. The issue with this is that the form hides, I see a flash of the Word document then the Userform comes back in front to obscure the Word doc once again....

Originally Posted by BigBas

How are you creating/referencing the Word object? Can you post some of your code?

I just created a quick mock-up example, and using the code I pasted above worked for me.

to add to this, once a user prints the Word doc, I really do need the focus to return back to the Userform..
Thank you sooooo much

If I'm not mistaken, you don't need to do all this. I'm going to post my sample code just to give an example. A userform is open on the screen. When I click on the userform, an instance of Word is created, and it is populated with a text string. The Word document takes focus, and the form is in the background. There is no reason to hide then show the form because it is still open behind the Word document.

Theoretically, you could print the Word document from within the VBA code, then close it.

Please Login or Register  to view this content.

PERFECT!!!!
Thank you sooooo much!!!

Not a problem!