Using VBA to Print duplex (two sided)
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 -- Helping Is always a good thing |
Using VBA to Print duplex (two sided)
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. filepage 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 "QuietMan" wrote: 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 -- Helping Is always a good thing |
All times are GMT +1. The time now is 09:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com