Using VBA to Print duplex (two sided)

  • Thread starter Thread starter QuietMan
  • Start date Start date
Q

QuietMan

Does anyone know the vba code to set the printer to print duplex.

Also to have it print duplex when the data being printed is on more than one
tab

Thanks
 
hi
in printing, basicly all excel does is send the data. excel has some
standards formats but not all primarily due to the large varity of printers
available on the market.
the rest is done by the printer. do you have access to a printer that prints
duplex. if not then excel(VB) cannot do what your printer is incapable of
doing.
file>page setup> options button.
this will call up the settings of your default printer. if you printer has
duplex printing, you can set it up here. otherwise sorry. you'll have to do
it the old fashion way. print ever other sheet then flip the stack over.
see this site for code on printed odd/even pages.
http://www.rondebruin.nl/print.htm#odd

regards
FSt1


regards
FSt1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Alternating between duplex and single side printing. 1
How to print duplex on a HP9000DN with the 'Flip on long edge' opt 1
Laser printers with automatic duplex printing 9
Word Word Print Macro in Citrix 0
Duplex not printing second page on back. 1
How do I code a print module to duplex? 1
Printing Duplex Copies in Excel 1
Printing Problem 8

Back
Top