Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    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?

  2. 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!

    Excel 2013: The Missing Manual

    + 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!

  3. #2
    5 Star Lounger kmurdock's Avatar
    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?
    Best, Kim

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts