changing paperbin /papertray in excel 2003

=?Utf-8?B?ZmxhbmRlcnNpdA==?=

Guest

Posts: n/a

10th Jul 2007

we wrote a program in vb.net and in part of it we have to print an excel
sheet several times, each time on a different tray of the printer. Is there a
way to change the paperbin from code.
I can't use the solutions of installing several printerdrivers for each
tray, or using sendkeys. We wrote a dll file to change the default printer
and even this gives problems because the users don't have the right to change
the printerdriver. Does anyone has any idea?

« Setting AutoFilter to "Show All" when worksheet is opened | Dynamic Cell Reference »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Crystal reports 8.5 for VB6 papertray direction	Cor Ligthert [MVP]	Microsoft Dot NET	1	30th Jan 2008 03:12 PM
Setting Paperbin Property On-the-fly	=?Utf-8?B?bGFuZGV5ZQ==?=	Microsoft Access Reports	0	19th Jul 2005 06:57 PM
Access 2003 --> Excel 2003 Numeric fields changing to text	Katie	Microsoft Access External Data	0	2nd Mar 2004 06:31 PM
SET printer.paperbin = (>= 256)	franky	Microsoft Access Reports	0	12th Aug 2003 04:39 PM
cannot set papertray on hp 4000 /8000	Markus Feldmann	Microsoft Windows 2000 Printing	0	29th Jul 2003 09:02 PM