Hi,
I'm looking to see if anyone has any information on how to change the output paper tray of a printer from VBA. I found out how to enumerate the trays and get their names from this article:
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=101
Now the next step is the trouble. How do I select a certain paper tray in Excel (make it the active output tray)? I've checked it out and it seems alot simpler in Word (Word.Document.PageSetup.FirstPageTray). There seems to be no such property in Excel. Any ideas?
Thanks