Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing multiple pages (2x2) double sided with single sided print | Excel Discussion (Misc queries) | |||
Print one-sided and override two-sided default | Excel Programming | |||
How to print single sided versus double sided? | Excel Discussion (Misc queries) | |||
How do I print excel document duplex (double sided)? | Excel Discussion (Misc queries) | |||
Do not print in duplex | Excel Programming |