Home > IT Answers > Microsoft Windows > Excel Page setup Landsacape
Dha
5 pts.
 Excel Page setup Landsacape
Landscape, Microsoft Excel, VBScript
How to write a VB script to change the Excel file page orientation to Landsacpe.

Software/Hardware used:
ASKED: June 25, 2009  9:20 AM
UPDATED: February 22, 2010  10:48 AM
RELATED QUESTIONS
Answer Wiki:
You can either use: ActiveSheet.PageSetup.Orientation = xlLandScape Or you can specify your own area on the sheet to be the printed by using: ActiveSheet.PageSetup.PrintArea = "A1:K30" Hope that helps :)
Last Wiki Answer Submitted:  February 22, 2010  10:48 am  by  Darraca   260 pts.
All Answer Wiki Contributors:  Darraca   260 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


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

 

I’m fairly certain this can be enacted through printer specific settings.

-Schmidtw

Schmidtw
 11,205 pts.