Excel UI gives very limited access to the printer settings.
Excel VBA is worse.

I had expected changes in Excel12:
NOTHING has been done in excel printing.
(excel a fancy interface which adds nothing at all)
You still cannot print a square rectangle. (my lithmus test)

The accepted workaround is to create a copy of the printer driver
in control panel, with the duplex settings you want... give it a
descriptive name and use that in the activeprinter string.



--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Frank wrote in


I have recorded a VBA macro when printing duplex on a HP9000DN with
the 'Flip on long edge' option, but it then just prints even an odd
pages separately.

How can I write a VBA macro that makes the printer print duplex in a
normal manner - i.e page 1 and page 2 instead of page 1 and 3?

Thanks

Frank