xl11x17 and xlTabloid are both 11x17 page sizes. For
PageSetup.PaperSize I tried the more intuitively named xl11x17 but
that threw an error.

Anyone know what the difference is?

Thanks,

Nicholas Hebb
BreezeTree Software
http://www.breezetree.com

Nick,
Check the object browser for the correct spellings for the values of this
enum. In my XL2003:

Const xlPaper11x17 = 17 (&H11)
Member of Excel.XlPaperSize

Const xlPaperTabloid = 3
Member of Excel.XlPaperSize

Still depends on if the print driver supports these values.

NickHK

"Nick Hebb" wrote in message
oups.com...
xl11x17 and xlTabloid are both 11x17 page sizes. For
PageSetup.PaperSize I tried the more intuitively named xl11x17 but
that threw an error.

Anyone know what the difference is?

Thanks,

Nicholas Hebb
BreezeTree Software
http://www.breezetree.com

NickHK -

Yeah, I typed it wrong. The constants are xlPaper11x17 and
xlPaperTabloid. Both produce an 11x17 paper size, though.

I did find a KB article (http://support.microsoft.com/kb/244639/en-us)
that lets you enumerate the paper sizes supported by the active
printer, but I find that between printers the names are consistent for
the same paper size. I guess the option will be to set it and test for
errors.

Nicholas Hebb
BreezeTree Software
http://www.breezetree.com

Nick,
It will depend how the driver was written. Try one value and if it fails,
try the other.

Seems there also:
xlPaperLedger. Ledger (17 in. x 11 in.)
which the same physical size but rotated (?).

I never had the need to print to such paper, so I have no idea which is more
commonly used.

NickHK

"Nick Hebb" wrote in message
oups.com...
NickHK -

Yeah, I typed it wrong. The constants are xlPaper11x17 and
xlPaperTabloid. Both produce an 11x17 paper size, though.

I did find a KB article (http://support.microsoft.com/kb/244639/en-us)
that lets you enumerate the paper sizes supported by the active
printer, but I find that between printers the names are consistent for
the same paper size. I guess the option will be to set it and test for
errors.

Nicholas Hebb
BreezeTree Software
http://www.breezetree.com