Thread: Duplex Printing in Macro
2014-05-22, 11:52 #1
- Join Date
- Jan 2001
- Tacoma, Washington, USA
- Thanked 1 Time in 1 Post
Duplex Printing in Macro
I'm writing a macro for a Word 2010 user where it sends the active document to a specific copier to print double sided. I'm not finding a way to achieve duplex setting, though. Has someone here been able to make that work?Daisy
Subscribe to our Windows Secrets Newsletter - It's Free!
Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!
+ Get this BONUS — free!
Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!
2014-05-23, 12:06 #2
- Join Date
- Feb 2003
- Pacific Grove, California, USA
- Thanked 19 Times in 18 Posts
I, too, was unable to find any duplex parameter in the VBA PrintOut command other than the one that adjusts output to accommodate manual duplexing.
A printer's ability to print in duplex mode is detected when Word displays the print dialog, based on the default printer. If your chosen printer is capable of duplexing, Word will offer you the ability to choose it in the dialog rather than displaying the properties of your printer and setting it there. It seems that Word only passes this information through to the print dialog for our convenience; the moment a non-duplexing printer is chosen, the options for auto-duplexing disappear.
Perhaps the added complexity in providing a parameter for a feature that is often not possible to use, and therefore potentially creating a lot of VBA mischief, caused the fine folks at Msoft to decide not to include it for our own safety and well-being?
Short of finding a way to manipulate the copier itself--sending it escape codes to put it into duplex mode, for example--I'm not sure VBA can directly address this task. With the model of copier, perhaps a hardware expert could help?