PDA

View Full Version : Duplex printer needs help



Elvisman
09-06-2010, 02:40 AM
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:

Sub duplex()

setprinterduplex Application.ActivePrinter, 2
ActiveSheet.PrintOut

End Sub

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
09-06-2010, 10:15 AM
Untested.

xlWB.PrintOut(, , , , "PQ-Purchasing-BH600-02")

Change the printer in quotes to your default printer.