Printing through a macro

[Kevin]

I have the following code which print selected sheets in a
workbook.
Sub test2()
For Each cell In Selection
On Error Resume Next
Sheets(cell.Value).PrintOut Copies:=cell.Offset(0, 1).Value
On Error GoTo 0
Next
End Sub
Is there a way to change the properties of the printer
when this macro is run to use the manual sheet feeder
instead of the default setting?

Thanks in advance for any suggestions.

Kevin

 

[Dave Peterson]

Record a macro when you change that property on your printer.

Look at the code generated. Do you see anything that looks like you could
include in your code?

I didn't see anything useful when I did it.

But how about installing another printer driver set up for manual feed?

Then you can change the printer, print, and change back.

(The recorder will get those changes.)

 

[Kevin]

I can't seem to get the macro to change the properties of
the printer. What am I doing wrong?

 

[Dave Peterson]

Nothing wrong.

I didn't get any recorded code either. That's why I suggested the alternate method.