+ Reply to Thread
Results 1 to 4 of 4

.PaperSize = xlPaper11x17 Not Working; "Unable to set the Paper Size of the PageSetup cl"

  1. #1
    Registered User
    Join Date
    09-18-2011
    Location
    Durham, CA USA
    MS-Off Ver
    Excel 2010
    Posts
    8

    .PaperSize = xlPaper11x17 Not Working; "Unable to set the Paper Size of the PageSetup cl"

    Greetings,

    I am constructing a spreadsheet within Access that I ultimately want to spin out to a "11x17" landscape PDF.
    I keep getting the "Unable to set the Paper Size of the PageSetup class." error (1004). I've tried using xlPaperTabloid and get the same error. I've also tried using the actual numeric for xlPaper11x17 (which is 17) and that doesn't work.

    I've set my default printer to a printer that accomodates 11 x 17.

    I've recorded a macro that worked and pasted that into my code, but it still errors out on the PaperSize line.

    I've seen LOTS of posts regarding this issue, but haven't found a solution. Any help would be appreciated! Code is shown below.

    Please Login or Register  to view this content.
    Jonathan Mulder
    California Department of Water Resources
    Red Bluff, CA USA

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: .PaperSize = xlPaper11x17 Not Working; "Unable to set the Paper Size of the PageSetup

    Hello JonMulder,

    Some printer drivers do not have the ability to select different paper trays or sizes. Or it could be there is no 11x17 paper loaded in the paper tray of your selected printer.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Registered User
    Join Date
    09-18-2011
    Location
    Durham, CA USA
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: .PaperSize = xlPaper11x17 Not Working; "Unable to set the Paper Size of the PageSetup

    Thanks for the response. I forgot to check "Notify", so didn't see this until today. As it stands, I've done a work-around by making the paper size legal.

  4. #4
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: .PaperSize = xlPaper11x17 Not Working; "Unable to set the Paper Size of the PageSetup

    I know this question is 5 years old, but while working on something else I found a solution, which may help someone else in the future.

    It seems that Excel (2016) DOES NOT recognize the existence of xlPaper11x17.

    Excel (2016) does recognize xlPaperTabloid which is the same size and works for me even when using a Printer whose Driver DOES NOT support 11 x 17 Paper.
    Please Login or Register  to view this content.
    Reference: https://docs.microsoft.com/en-us/off...el.xlpapersize

    Please NOTE that there are several (probably older) Paper Size Numbers that Excel does not Recognize. For Example:
    2 = xlPaperLetterSmall (8.5 in x 11 in)
    4 = xlPaperLedger (17 in x 11 in)
    and many many more

    I'm not sure if it is Excel (2016) that DOES NOT RECOGNIZE the Paper Size or if it is the Printer Driver that DOES NOT RECOGNIZE the Paper Size.

    Lewis
    Last edited by LJMetzger; 05-24-2020 at 11:33 AM.

+ 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. Unable to set the PaperSize property of the PageSetup class
    By AMagnan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-11-2014, 04:34 PM
  2. [SOLVED] PageSetup.CenterHeader = "My Heading" --> I need to change this font size from 8 to 16.
    By HerryMarkowitz in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-30-2013, 09:52 AM
  3. VBA Code to specify paper size as Custom "User Defined"
    By mdlpjr in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-09-2013, 01:50 AM
  4. [SOLVED] what is 11" X 17" paper size called in excel page setup?
    By Jeremy in forum Excel General
    Replies: 3
    Last Post: 10-08-2005, 01:05 PM
  5. [SOLVED] PageSetup.PaperSize
    By Sandy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-18-2005, 03:06 PM

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