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
 
Back
Top