Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Below is my code, and the escape sequence is correct as it does work in an
old wordperfect macro, but in excel this printout never goes to the correct tray, any ideas? Thanks. ActiveSheet.PageSetup.PrintArea = "$A$1:$U$52" With ActiveSheet.PageSetup .LeftMargin = Application.InchesToPoints(0.45) .RightMargin = Application.InchesToPoints(0.25) .TopMargin = Application.InchesToPoints(0.73) .BottomMargin = Application.InchesToPoints(0.4) .HeaderMargin = Application.InchesToPoints(0.5) .FooterMargin = Application.InchesToPoints(0.43) .PrintQuality = 600 End With ' selects the manual page tray without printing SendKeys "{ESC}&l8H" ActiveWindow.SelectedSheets.PrintOut Copies:=2, Collate:=True |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do you set your printer to manual feed a worksheet during pri. | New Users to Excel | |||
Default Paper Tray | Excel Discussion (Misc queries) | |||
manual feed print options | Excel Discussion (Misc queries) | |||
Set Print to Manual Feed | Excel Programming | |||
Print all worksheets from same tray | Excel Programming |