Excel page setup by macro

[Anonymous]

I need to set the page orientation in Excel printout to Landscape from QV macro. Tried ActiveSheet.PageSetup.Orientation=xLandscape - it doesn't work. The error is in PageSetup.Orientation, apparently QV vbscript doesn't like the Orientation part.
Anyone knows what can be used instead?

Thank you.

[#2]

Try Orientation = xlLandscape (untested)

[Anonymous]

Thanks DK_ASN,
Actually this is exactly what I tried and what didn't work - sorry for mistyping in my opening post. It was Orientation = xlLandscape.

[#4 · Accepted solution]

Found this elsewhere in the forum: XLsheet.PageSetup.Orientation = 2 'Landscape

You might want to give it a go (I haven't the time to test)

[Anonymous]

This is exactly what I'm looking for - thanks!