I need to get the number assigned to paper trays on laser printers and
copiers to add this to a macro for bin selection. I believe there may be a
macro to find this out but not sure what this is.

Have tried choosing File, Page Setup whilst running a macro and whilst this
gives me the bin number on the copiers we use, when I put this code in my
current macro, it doesn't select correct bin - just picks from the default
tray.

On our HP laser printers, when I select File, Page Setup, I just get Upper
or Lower Tray in the code. I actually do have the numbers for the printers
from our consultant who wrote the macro, but as we will probably be getting
new models, I would like to know where/how to get the actual bin numbers.

Thanks in advance.

Re: Paper Tray Bin Selection macro by Jonathan

Jonathan
Thu Feb 09 12:06:44 CST 2006


"Jean Pereira" <JeanPereira@discussions.microsoft.com> wrote in message
news:075A593A-F56D-4907-A6B3-BB34A2E86E82@microsoft.com...
>I need to get the number assigned to paper trays on laser printers and
> copiers to add this to a macro for bin selection. I believe there may be
> a
> macro to find this out but not sure what this is.
>
> Have tried choosing File, Page Setup whilst running a macro and whilst
> this
> gives me the bin number on the copiers we use, when I put this code in my
> current macro, it doesn't select correct bin - just picks from the default
> tray.
>
> On our HP laser printers, when I select File, Page Setup, I just get Upper
> or Lower Tray in the code. I actually do have the numbers for the
> printers
> from our consultant who wrote the macro, but as we will probably be
> getting
> new models, I would like to know where/how to get the actual bin numbers.
>
> Thanks in advance.

Controlling the Printer from Word VBA
Part 1: Using VBA to Select the Paper Tray
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=101


--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org