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?

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?

"Tom Ogilvy" wrote:

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?


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.