+ Reply to Thread
Results 1 to 2 of 2

Macro to print Front and Back side

  1. #1
    Registered User
    Join Date
    10-17-2019
    Location
    Tulsa, oklahoma
    MS-Off Ver
    2013
    Posts
    1

    Macro to print Front and Back side

    Hi, I need help with macro that would print front and back (Duplex) of the page. I have this document that get printed from multiple printer and all of the printer are supported front and back page. I need a macro where they press a button and it will on front and back page instead of 2 pages.

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,913

    Re: Macro to print Front and Back side

    That setting is set on Printer's side and not easily accessible from VBA, as it's different for each printer.

    What I'd recommend, is to set up alternate print device for each of your printer with property set to do double sided print (using Windows to add printer). Making sure to name it something like...
    "DoubleSided-PrinterName" or some such that makes it easy to identify.

    Then just use appropriate printer to print double sided print in your code.
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] [SOLVED] How do I print two worksheets front and back?
    By Jeri in forum Excel General
    Replies: 8
    Last Post: 03-07-2019, 03:29 AM
  2. Replies: 2
    Last Post: 03-24-2015, 09:48 PM
  3. Print Front to back worksheet (upside down)
    By wetrain17 in forum Excel General
    Replies: 1
    Last Post: 04-14-2011, 06:11 PM
  4. Print Sheets front to back
    By maui1girl in forum Excel General
    Replies: 2
    Last Post: 12-02-2007, 07:20 PM
  5. [SOLVED] I can not get excel to print on front and back can anyone help me.
    By de_stap in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 02-01-2006, 02:40 PM
  6. [SOLVED] How to print 2 Excel pages side by side on 1 printed page?
    By Kathy Install in forum Excel General
    Replies: 1
    Last Post: 09-29-2005, 01:05 PM
  7. [SOLVED] RE: How can I print on the front and back of a page in excel?
    By Jonathan Cooper in forum Excel General
    Replies: 0
    Last Post: 09-29-2005, 10:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1