Excel 97 VB Print Tray commands

[Jon Gammon]

I am trying to macro the printing of an excel file to
(first) one tray of a printer and (second) to another tray.

I can do this manually by selecting the appropriate print
trays, but when I record those steps the resulting macro
doesn't work because VB doesn't store any paper source or
tray commands.

I don't have this problem in Word 97.

Is there a way around this please?

Many thanks

Jon Gammon