+ Reply to Thread
Results 1 to 6 of 6

printing double sided

  1. #1
    Forum Contributor
    Join Date
    06-23-2007
    Posts
    690

    printing double sided

    hi guys i have a macro that prits 8 sheets for me all single sinded
    is it possible to make the macro print them double sided?

    i cant test this at home as i dont have a printer

    as always all help appreciated

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419
    In order to print duplex in excel you need to create another printer with duplex printing set as default.
    The in code you can change the active printer.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Contributor
    Join Date
    06-23-2007
    Posts
    690
    hi andy
    the printer at work allows duplex printing on the one machine as it switches it over itself
    can i not get excel to record what im doing in printer properties or is that not possible?

  4. #4
    Forum Expert Simon Lloyd's Avatar
    Join Date
    03-02-2004
    Location
    locked in the cage
    MS-Off Ver
    All the ones my homepage shows
    Posts
    3,161
    You can only print them double sided if your printer is capable, as far as i know!

    That said you can bring up the printer dialogue box and select what you want to do from there its done like this:
    Please Login or Register  to view this content.
    Not all forums are the same - seek and you shall find

  5. #5
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419
    You can try recording but I doubt you will get anything.

    In word you could, with code, tell the page to print duplex.
    But not in excel.

    So you need to add another printer queue. It will point to the same physical printer but the default setting will be duplex.

  6. #6
    Forum Contributor
    Join Date
    06-23-2007
    Posts
    690
    thanks andy

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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