Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi All,
I use a special paper size in a macro (Win XP, XL2003) with these (and some else) commands: With ActiveSheet.PageSetup .PaperSize = 126 ... End With It works fine changing the actual paper tray of the printer (HP LaserJet 1320nw) to tray 2. After finishing the print job I'd like to reset paper tray to the default automatic tray selection setting also from VBA. I can't do that neither from VBA nor via Control panel/Printers setting. In the latter case the new setting is displayed (I tried automatic selection an 1st tray as well), but it has no effect on the printer, it prints to tray 2, I have to switch it off and on again to restore the original default setting. Any idea on doing this automatically? Thanks, Stefi |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Setting Trays | Excel Discussion (Misc queries) | |||
Printing to seperate printer trays................... | Excel Discussion (Misc queries) | |||
members on my network printer not able to print to default printer | Excel Discussion (Misc queries) | |||
how do i select different printer trays using macros | Excel Programming | |||
Controlling two different printer trays | Excel Programming |