word landscape 1

[matrixindicator]

with VBA I am creating an word document with data, qeuries from my database. I need to view and save the document in landscape. I did some research but up to now I do not find info on how to view and save my word document in landscape (to view neat the data).

I found a few methods like Orientation = landscape, not working properly. I use version access 2000.

regards.

 

[grtammi]

Did you try the <word object>.PageSetup.Orientation = Landscape?

I think landscape is the correct constant to use; you may have to view documentation to find the correct constant value is this is not correct.

Greg

 

[PHV]

yourWordObject.ActiveDocument.PageSetup.Orientation = 1 'wdOrientLandscape

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[matrixindicator]

AppWord.ActiveDocument.PageSetup.Orientation = 1

a simple solution but I spend a lot of time on it trying to find a working one. thanks.