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
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