Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I can't quite get the syntax for printing to the manual feed tray
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 | |
|
|
Similar Threads | ||||
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 |