How can I select printer drawer?

How can I incorporate a little script to set the drawer on the printer I am using? I already have it set to choose the printer I want, but Need a little help selecting what drawer to use.


Here is my current code:

Please Login or Register  to view this content.

Thanks for any help!

Hi

This is something I have struggled with as in Excel as, unlike word, you cannot select the paper source from VBA.

A possible workaround is to add a duplicate printer and have the default paper source set to the one you would like.

I have not found any other way around this at present.

Regards

Jeff

Hey thanks. I hate I cant designate a drawer, but you have solved my problem really. I was so caught up in sending it to a particular drawer I didn't even think about sending it to another printer. Problem solved, thanks again.