S
Stefi
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
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