Pasting a form into Word

[AlanArons]

I have been using the faq "
faq184-4212
by Mike Gagnon. Great Stuff. Thanks Mike.

My problem is I want to print the screen in landscape and have the image be maximized to the full width/height of the page.

The landscape issue is resolved with the line
oword.ActiveDocument.PageSetup.Orientation= 1

but, I have been unable to find the code to maximize the image.

Any help is appreciated.

Alan Arons

 

[white605]

Look at vba applications forum post:

http://www.tek-tips.com/viewthread.cfm?qid=1391314

It references in word inlineshape object
With .ActiveDocument.InlineShapes(.ActiveDocument.InlineShapes.Count)
.Height = 36
.Width = 156
End with
I think you will have to play with it to find the right size
wjwjr

This old world keeps spinning round - It's a wonder tall trees ain't layin' down