Duplex printer needs help

[Elvisman]

Hello,

I'm trying to write a vba code for duplex printing. However, I don't know what code I should use. I found something on the internet and I tried this:

[VBA]Sub duplex()

setprinterduplex Application.ActivePrinter, 2
ActiveSheet.PrintOut

End Sub[/VBA]

This however doesn't work. Excel 2007 doesn't recognize the 'setprinterduplex' code and that's also the reason that there appear no capitals in it.

Do you know what code I should use for duplex printing? I would be glad to receive an answer from you,

cheers,

Jeroen

[austenr]

Untested.

[VBA]xlWB.PrintOut(, , , , "PQ-Purchasing-BH600-02")[/VBA]

Change the printer in quotes to your default printer.