View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
honestlylion honestlylion is offline
external usenet poster
 
Posts: 1
Default program to print some landscape, some portrait?


I am creating a two page device status report in Excel. VBA code will be
run to populate the fields of the report and save a the report as a file
- one for each device listed in the database (approx. 1000). It is
necessary for me to print each of these reports for our contractors,
and desireable that each two page report be printed on a single page
(front and back).

The issue is that the first page needs to print in a Portrait format,
and the second in Landscape format. Is it possible to print two pages
of the same worksheet back-to-back AND have each side in the desired
format(portrait/landscape). Any suggestions to accomplish this are
greatly appreciated.


--
honestlylion
------------------------------------------------------------------------
honestlylion's Profile: http://www.excelforum.com/member.php...o&userid=31674
View this thread: http://www.excelforum.com/showthread...hreadid=513697