Excel

Ever needed to change the Printer tray to say print A3 from A4.

Here is a routine that worked for me on Win XP / Excel 2000, so I do not know if it will

work on your system, but testing when I originally did it under Win98 / Excel97 yeilded the same results.

Here is a routine that will do this for you...yes......using APIs !