Unable to set the PaperSize property of the PageSetup class

Hello,

I'm trying to setup the PageSetup properties using VBA. All properties are working fine except the PaperSize property.
I've used all XlPaperSize constants (xlPaper11x17, xlPaperLetter, etc.) and nothing works. I've also used the matching numbers instead of the constants with the same result. I then recorded a macro to grab the value for the paper size and got 134 for 11x17 size. If I use that value then it works but 134 is not one of the possible values for XlPaperSize as specified in the documentation.
I'm a little bit confused as to what value I should be using. 134 works for me on my computer but it fails for another user on another machine for a different printer. 11x17 is supported on all printers.
What I need to do is to be able to set the page size to 11x17 and that it will work for all users on all computers for all printers.

Thank you for your help.
Alain

When I used the macro recorder (Excel 2003), the enumeration for 11 x 17 printer showed up as:

Please Login or Register  to view this content.

The printer is a Canon MF5700 series laser. It let me set up for 11 x 17, but I don't think it has the ability to feed 11 x 17 paper.

Lewis

Hello Lewis,

Unfortunately the macro recorder (Excel 2007) returned 134 (not xlPaper11x17). I have no idea where that value came from and why it's not one of the values specified in the documentation. I wish it would be as simple as what you got (and it should).

Thanks for the help
Alain

Hi Alain,

I would try 3.

From the enumeration list I found, '3' makes sense as 11 x 17, since the first few paper sizes allocated were probably for the most common available at Microsoft many many years ago: http://www.datapigtechnologies.com/d...umerations.txt

Excerpts from the list (rearranged in numerical order):
xlPaperLetter = 1
xlPaperLetterSmall = 2
xlPaperTabloid = 3
xlPaperLedger = 4
xlPaperLegal = 5

Lewis

Sorry Lewis, I tried them all, all the matching numerical values for each of the XlPaperSize constants, and none are working. But 134, which doesn't match any of the XlPaperSize constants, works.