Duplex Printing

[Guest]

I am using the code from Microsoft KB article Q230743 to print in duplex from
Excel 2003 in a WinXP SP2, Office 2003 environment.

The code appears to fail on the openprinter function. The code works in
Word 2003, but when used in Excel it fails.

Does anyone have any advice?

 

[Tom Ogilvy]

Excel doesn't have a printer object - so how are you getting the printer
name. ActivePrinter doesn't return just the printer name.

 

[Guest]

Excel doesn't have a printer object - so how are you getting the printer
name. ActivePrinter doesn't return just the printer name.

--
Regards,
Tom Ogilvy




I am trying to use Windows API to access the printer (ActivePrinter). Will this work, or is there another approach that I should be using?

regards

Paul.