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
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
