Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing
How can I write a macro for duplex printing?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing
Record a macro when you change that setting.
But sometimes(all the time???) excel won't be able to control that setting. One solution is to install a second printer driver and have its default setting as duplex. Then when you need to use a duplex printer, you can change printers, print, then change back. (And excel can control this). And if your printer doesn't support duplex, you could use a macro by Dana DeLouis: http://groups.google.com/groups?thre...%40cppssbbsa05 (It actually prints all of the odd pages, then you send the pages through your printer to print the even pages. Make sure you flip the sheets over. <vbg.) Pavel wrote: How can I write a macro for duplex printing? -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing
I have an HP LaserJet 2200d which is capable of printing duplex. Even if I
follow your instructions, my macro won't print duplex. It does run it thru the printer as if it was printing duplex but 1 side is blank. Any other ideas or suggestions? "Dave Peterson" wrote: Record a macro when you change that setting. But sometimes(all the time???) excel won't be able to control that setting. One solution is to install a second printer driver and have its default setting as duplex. Then when you need to use a duplex printer, you can change printers, print, then change back. (And excel can control this). And if your printer doesn't support duplex, you could use a macro by Dana DeLouis: http://groups.google.com/groups?thre...%40cppssbbsa05 (It actually prints all of the odd pages, then you send the pages through your printer to print the even pages. Make sure you flip the sheets over. <vbg.) Pavel wrote: How can I write a macro for duplex printing? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 printing problem--printing 1 document on 2 pages | Excel Discussion (Misc queries) | |||
Excel Printing --Borders are not printing on the same page as data | Excel Discussion (Misc queries) | |||
Printing a heading on each new page when printing | Excel Discussion (Misc queries) | |||
Enable Double sided printing contiuously when printing multiple s. | Excel Discussion (Misc queries) | |||
Printing? Worksheets not printing the same on multiple pc's! | Excel Programming |