Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

mov
Esteemed Contributor III

Excel page setup by macro

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.

Tags (3)
1 Solution

Accepted Solutions
Not applicable

Excel page setup by macro

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)

4 Replies
Not applicable

Excel page setup by macro

Try Orientation = xlLandscape (untested)

mov
Esteemed Contributor III

Excel page setup by macro

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.

Not applicable

Excel page setup by macro

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)

mov
Esteemed Contributor III

Excel page setup by macro

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

Community Browser