Printing UpperBin en LowerBin

[Rob Staal]

Dear members

Does anyone of you know how to print in Excel.
I want to make VBA code to print to the upperbin of my printer and to print
to the lowerbin of my HP printer.
Page 1 has to be printed to the upperbin en page 2 and the rest of the
pages to the lowerbin.
I do not know if it is possible in Excel VBA.

Greetings,

Rob Staal

 

[Jason Morin]

It's not easy. These articles may help:

HOWTO: Determine Available PaperBins with
DeviceCapabilities API:

http://support.microsoft.com/default.aspx?scid=kb;EN-
US;194789

Changing the Paper Source Using SendKeys:

http://support.microsoft.com/support/kb/articles/Q135/7/91.
asp

OFF2000: Macro to Obtain a List of Paper Names Supported
by the Active Printer

http://support.microsoft.com/support/kb/articles/q244/6/39.
ASP

 

[Dave Peterson]

Instead of changing the printer options, maybe you could set up multiple
printers (same physical printer). Set them up the way you want (windows start
button|settings|printers) and then just print to the printer of your choice.

 

[Rob Staal]

Dear Jason,

Thanks for your answer.
The articles you mentioned where no longer avaieble

Greetings,

Rob Staal

 

[Rob Staal]

Dear Dave,

Thanks for your answer,
i think i can use it.

Greetings,
Rob Staal