Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
Try Orientation = xlLandscape (untested)
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.
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)
This is exactly what I'm looking for - thanks!