+ Reply to Thread
Results 1 to 5 of 5

Print two sided pages in Word?

  1. #1
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Print two sided pages in Word?

    I am not a big Word user, but is there a way to force two side page print in word VBA?
    Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
    I am the real 'Napster'
    The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...

    If you receive help please give thanks. Click the * in the bottom left hand corner.

    snb's VBA Help Files

  2. #2
    Forum Expert JLGWhiz's Avatar
    Join Date
    02-20-2011
    Location
    Florida, USA
    MS-Off Ver
    Windows 10, Excel 2013
    Posts
    2,070

    Re: Print two sided pages in Word?

    Two sided printing would normally be based on the printer settings and not MS Word parameters. You can set up the printer parameters through the Page Setup facility. If there is no Front and Back option on your printer parameters, then you can manually set the printer to print every other page by using the 'Pages to Print' and making two print run with the odd pages (1, 3, 5, etc.) on one print run and the even pages (2, 4, 6, etc.) on the second run. You would then have to keep the first run organized in the correct page order and reload that batch into the feed tray blank side up for the second run.
    Last edited by JLGWhiz; 10-02-2018 at 09:06 AM.
    Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
    Just when I think I am smart, I learn something new!

  3. #3
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: Print two sided pages in Word?

    That is going to be very hard when you are looping through a couple hundred of word files while printing them simultaneously. Hence the need to set the printer programatically.

  4. #4
    Forum Expert JLGWhiz's Avatar
    Join Date
    02-20-2011
    Location
    Florida, USA
    MS-Off Ver
    Windows 10, Excel 2013
    Posts
    2,070

    Re: Print two sided pages in Word?

    To set it programmatically, you use the 'PageSetup' method to set the parameters, but if your printer has to have front and back capability to do that.

    Disregard that. The duplex parameter is not incluced in PageSetup properties. One way to get the code is to turn on the recorder and do a manual set up. Then take the recorded code and merge it into your other code. My printer does not have duplex capability so I cannot do that for you.
    Last edited by JLGWhiz; 10-02-2018 at 11:32 PM.

  5. #5
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,901

    Re: Print two sided pages in Word?

    What does this have to do with Outlook?

    Anyway, to the best of my recollection, that is one of the properties that need API calls in VBA to set prtdevmode for the printer.
    Rory

+ 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] VBA print single sided
    By BoundToExcel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-05-2019, 05:29 PM
  2. Replies: 1
    Last Post: 03-24-2016, 05:28 PM
  3. VBA Code to Convert/Print Selected Pages of Word Document to PDF File
    By DD1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-05-2016, 01:59 AM
  4. [SOLVED] VBA Code to Convert/Print Selected Pages of Word Document to PDF File
    By DD1 in forum Word Programming / VBA / Macros
    Replies: 5
    Last Post: 08-17-2015, 02:18 AM
  5. Cant figure out how to set a code to print 2 pages double sided...
    By Legend Rubber in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-04-2014, 11:15 AM
  6. How to print single sided versus double sided?
    By bobm217 in forum Excel General
    Replies: 1
    Last Post: 12-06-2005, 09:10 PM
  7. How can I print two sided documents in Excel?:print double-sided,
    By Myrna Larson in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 06:05 AM

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