ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do you print odd numbered pages (https://www.excelbanter.com/excel-discussion-misc-queries/128880-how-do-you-print-odd-numbered-pages.html)

Printing pages

how do you print odd numbered pages
 
i need to print on both sides of the paper like a book full pages on each
side. Is there way to do this? ie printing odd numbered pages and then even
numbered pages?

Martin Fishlock

how do you print odd numbered pages
 
There are a number of ways to do it. Here are three.

1. Check if your printer can do it for you. Sometimes it allows you to do it
with a manual duplex option if it is not automatic.
2. Consider printing to a pdf printer using Adobe or some other option like
PDF Redirect (you also have to install the ghost script files you can get
them there too)
http://www.exp-systems.com/
Then you can print odd and even files in acrobat.
3. Write a macro that prints the pages 1,3,5.. and then request the user to
put the pages back in the printer and print on the other side may need to be
backwards and you will need to sort out the last page printing is it blank or
not.


--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Printing pages" wrote:

i need to print on both sides of the paper like a book full pages on each
side. Is there way to do this? ie printing odd numbered pages and then even
numbered pages?


Ron de Bruin

how do you print odd numbered pages
 
Hi

For a code example see
http://www.rondebruin.nl/print.htm#odd

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Printing pages" <Printing wrote in message
...
i need to print on both sides of the paper like a book full pages on each
side. Is there way to do this? ie printing odd numbered pages and then even
numbered pages?



VTXHonda

how do you print odd numbered pages
 
This solution looks like what I need, but where do you put this script? I
have no idea what to do with it.

Thanks in advance

"Ron de Bruin" wrote:

Hi

For a code example see
http://www.rondebruin.nl/print.htm#odd

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Printing pages" <Printing wrote in message
...
i need to print on both sides of the paper like a book full pages on each
side. Is there way to do this? ie printing odd numbered pages and then even
numbered pages?




Gord Dibben

how do you print odd numbered pages
 
See Ron's "where to store code" site.

http://www.rondebruin.nl/code.htm


Gord Dibben MS Excel MVP

On Thu, 18 Mar 2010 09:03:01 -0700, VTXHonda
wrote:

This solution looks like what I need, but where do you put this script? I
have no idea what to do with it.

Thanks in advance

"Ron de Bruin" wrote:

Hi

For a code example see
http://www.rondebruin.nl/print.htm#odd

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Printing pages" <Printing wrote in message
...
i need to print on both sides of the paper like a book full pages on each
side. Is there way to do this? ie printing odd numbered pages and then even
numbered pages?






All times are GMT +1. The time now is 08:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com