Thread: How to print duplex on a HP9000DN with the 'Flip on long edge' opt

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

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
<news:<60476A56-3DA3-4EA9-91AC-04BC31E3A1BF@microsoft.com>

> 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