LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,646
Default printer trays

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Setting Trays Don Excel Discussion (Misc queries) 1 January 29th 10 10:07 PM
Printing to seperate printer trays................... Steve Jones Excel Discussion (Misc queries) 1 September 30th 08 08:56 PM
members on my network printer not able to print to default printer smeheut Excel Discussion (Misc queries) 0 June 18th 07 06:42 PM
how do i select different printer trays using macros Mannis Excel Programming 2 April 6th 05 03:27 PM
Controlling two different printer trays Luc Dansereau Excel Programming 1 July 14th 03 05:47 AM


All times are GMT +1. The time now is 10:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"