topic Excel page setup by macro in QlikView https://community.qlik.com/t5/QlikView/Excel-page-setup-by-macro/m-p/172519#M502621 <HTML><HEAD></HEAD><BODY><P>Try Orientation = xlLandscape (untested)</P></BODY></HTML> Tue, 24 Aug 2010 13:47:06 GMT 2010-08-24T13:47:06Z Excel page setup by macro https://community.qlik.com/t5/QlikView/Excel-page-setup-by-macro/m-p/172518#M502620 <HTML><HEAD></HEAD><BODY><P>I need to set the page orientation in Excel printout to Landscape from QV macro. Tried <STRONG>ActiveSheet.PageSetup.Orientation=xLandscape</STRONG> - it doesn't work. The error is in PageSetup.Orientation, apparently QV vbscript doesn't like the <STRONG>Orientation</STRONG> part.<BR />Anyone knows what can be used instead?</P><P>Thank you.<BR /></P></BODY></HTML> Tue, 24 Aug 2010 13:31:15 GMT https://community.qlik.com/t5/QlikView/Excel-page-setup-by-macro/m-p/172518#M502620 Anonymous 2010-08-24T13:31:15Z Excel page setup by macro https://community.qlik.com/t5/QlikView/Excel-page-setup-by-macro/m-p/172519#M502621 <HTML><HEAD></HEAD><BODY><P>Try Orientation = xlLandscape (untested)</P></BODY></HTML> Tue, 24 Aug 2010 13:47:06 GMT https://community.qlik.com/t5/QlikView/Excel-page-setup-by-macro/m-p/172519#M502621 2010-08-24T13:47:06Z Excel page setup by macro https://community.qlik.com/t5/QlikView/Excel-page-setup-by-macro/m-p/172520#M502622 <HTML><HEAD></HEAD><BODY><P>Thanks DK_ASN,<BR />Actually this is exactly what I tried and what didn't work - sorry for mistyping in my opening post. It was Orientation = xlLandscape.</P></BODY></HTML> Tue, 24 Aug 2010 13:53:46 GMT https://community.qlik.com/t5/QlikView/Excel-page-setup-by-macro/m-p/172520#M502622 Anonymous 2010-08-24T13:53:46Z Excel page setup by macro https://community.qlik.com/t5/QlikView/Excel-page-setup-by-macro/m-p/172521#M502623 <HTML><HEAD></HEAD><BODY><P>Found this elsewhere in the forum: XLsheet.PageSetup.Orientation = 2 'Landscape</P><P>You might want to give it a go (I haven't the time to test)</P></BODY></HTML> Tue, 24 Aug 2010 14:03:38 GMT https://community.qlik.com/t5/QlikView/Excel-page-setup-by-macro/m-p/172521#M502623 2010-08-24T14:03:38Z Excel page setup by macro https://community.qlik.com/t5/QlikView/Excel-page-setup-by-macro/m-p/172522#M502624 <HTML><HEAD></HEAD><BODY><P>This is exactly what I'm looking for - thanks!</P></BODY></HTML> Tue, 24 Aug 2010 14:19:25 GMT https://community.qlik.com/t5/QlikView/Excel-page-setup-by-macro/m-p/172522#M502624 Anonymous 2010-08-24T14:19:25Z