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

"Paul" wrote in message
...
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?