Portrait/Landscape print issue

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.

You could print each range separately (changing the print setup each time)--and
manually turn the paper over.

You could use a macro, but I think you'd still have to swap the paper manually.

=====
How about an untested suggestion?

Print range 1 to a file (using the correct printer)
change the setup and print range 2 to a different file.

Shell to DOS and copy those two files to the printer.

copy /b prt1.prn + prt2.prn lpt1

It might work????



honestlylion wrote:
>
> 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=513651

--

Dave Peterson