Home > IT Answers > Development > Set Page orientation
ConFlicker
210 pts.
 Set Page orientation
VBScript, VBScript Functions
Can anyone help identify how to set the Page Layout Orientation of an XLSX file in VBS?  I am using the below script example for reference.

Set obj = CreateObject("Excel.Application") Set objWorkbook = obj.Workbooks.Open("C:pathtest.xlsx") obj.ActiveSheet.PageSetup.Orientation = xlLandscape obj.ActiveWorkbook.Saveas "C:pathtest.xlsx" obj.ActiveWorkbook.Close


Thank you.



Software/Hardware used:
ASKED: March 21, 2012  3:35 PM
UPDATED: March 21, 2012  4:23 PM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _