Thread: Difference between xl11x17 and xlTabloid (PageSetup)?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
  
Posts: 4,391
Default Difference between xl11x17 and xlTabloid (PageSetup)?
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



Reply With QuoteReply With Quote