5 pts.
 Excel Page setup Landsacape
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

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.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

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

-Schmidtw

 11,205 pts.