Consulting

Results 1 to 2 of 2

Thread: Duplex printer needs help

  1. #1
    VBAX Newbie
    Joined
    Aug 2010
    Posts
    2
    Location

    Duplex printer needs help

    Hello,

    I'm trying to write a vba code for duplex printing. However, I don't know what code I should use. I found something on the internet and I tried this:

    [VBA]Sub duplex()

    setprinterduplex Application.ActivePrinter, 2
    ActiveSheet.PrintOut

    End Sub[/VBA]

    This however doesn't work. Excel 2007 doesn't recognize the 'setprinterduplex' code and that's also the reason that there appear no capitals in it.

    Do you know what code I should use for duplex printing? I would be glad to receive an answer from you,

    cheers,

    Jeroen

  2. #2
    Moderator VBAX Master austenr's Avatar
    Joined
    Sep 2004
    Location
    Maine
    Posts
    1,983
    Location
    Untested.

    [VBA]xlWB.PrintOut(, , , , "PQ-Purchasing-BH600-02")[/VBA]

    Change the printer in quotes to your default printer.
    Peace of mind is found in some of the strangest places.

Posting Permissions

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