Printing odd and even pages

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kdj - 19 Feb 2004 13:03 GMT

Hello

Does anyone know how to print odd and even pages so that I
can end up with a duplex effect, even though I have a
simple printer? I have 100 pages that I want back-to-back.

Thanks!
kdj

Reply to this Message

Bill Ridgeway - 19 Feb 2004 17:55 GMT

Try looking at the printer software. Depending on the printer and its
software, you should be able to configure it to duplex. Regards.

Bill Ridgeway
Computer Solutions

> Hello
>
[quoted text clipped - 4 lines]
> Thanks!
> kdj

Reply to this Message

Paul Cundle - 19 Feb 2004 18:55 GMT

Failing that, a simple macro such as the following would do the job:

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
For a = 1 To 100 Step 2
ActiveWindow.SelectedSheets.PrintOut From:=a, To:=a
Next a

MsgBox "Now turn the paper over"

For a = 2 To 100 Step 2
ActiveWindow.SelectedSheets.PrintOut From:=a, To:=a
Next a
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Might be a little trickier if you have automatic page numbering though.

Paul C,

Signature

> Try looking at the printer software. Depending on the printer and its
> software, you should be able to configure it to duplex. Regards.
[quoted text clipped - 9 lines]
>> Thanks!
>> kdj

Reply to this Message

On Film - 19 Feb 2004 22:24 GMT

A bit cumbersome but if you REALLY want that, you could use a PDF
driver, such as pdf995 (a freebie) to print the spreadsheet to a PDF
file. Then in Acrobat, print by odd or even pages. In Acrobat,
select Automatic Orientation.

Mike

>Failing that, a simple macro such as the following would do the job:
>
[quoted text clipped - 13 lines]
>
>Paul C,

Reply to this Message