Making printers OBEY!

[CybOrg]

I'm writing a little snippet of code to print all Excel sheets in a folder - could be something like 30 sheets at a time. I've got a printer that's duplex capable - the problem is I can't figure out how to get that mother to actually print on both sides from within the code.

I've seen references to PrtDevMode, but those were... eh, rather dated... Is that still the only way to do it?

/Cy

 

[Jon4747]

Hi,
Printer.Duplex = 2

Jon

 

[CybOrg]

Thanks for the reply. Problem is I get an 'object required' error when I try to use it like I do below:

Printer.Duplex = 2
ActiveWorkbook.PrintOut Copies:=1, Collate:=True

/Cy