Thread: Envelope Size
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robin Clay[_4_] Robin Clay[_4_] is offline
external usenet poster
 
Posts: 40
Default Envelope Size

Greetings ! and a Happy New Year !

The envelopes I wish to use are 163 mm x 114 mm.

How can I set up Excel to print to that size on my HP Laserjet 4L printer?


It seems as if VBA / Excel only has a limited number of envelope sizes -
#10
C5 (162 x 229)
DL (110 x 220
B5 (176 x 250)
Monarch
.... which can be applied by eg
"ActiveSheet.PageSetup.PaperSize = xlPaperEnvelopeC5"


Regards

Robin