Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 694
Default 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?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,123
Default 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?


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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?



  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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?




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Too many pages to print off danc Excel Discussion (Misc queries) 2 March 15th 06 08:10 AM
?set up a print range to cover multiple pages in excel JBC Excel Worksheet Functions 3 March 6th 06 03:04 PM
Print Odd/ Even or specified pages in excel at a time. NAVEEN Excel Discussion (Misc queries) 1 February 21st 06 11:07 AM
Varying page Excel report judypudy Excel Discussion (Misc queries) 6 July 13th 05 08:39 PM
print different row titles in one sheet w/ many pages Carman Law Excel Worksheet Functions 2 May 24th 05 12:08 PM


All times are GMT +1. The time now is 03:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"