Set Printing Preference (single/Double sided) with Macro

[McKilty]

My boss likes to print everything double-sided... except some or all
Excel documents. So he wants a Excel macro to print an Excel document
single-sided. I tried a simple macro, but it doesn't appears that is
an option.

Does anyone know how I can do this?

 

[Jay Freedman]

My boss likes to print everything double-sided... except some or all
Excel documents. So he wants a Excel macro to print an Excel document
single-sided. I tried a simple macro, but it doesn't appears that is
an option.

Does anyone know how I can do this?

See http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=116 for code to
set and reset duplexing. Although the article says it's for Word, the only part
that's specific to Word VBA is in the examples that show how to use the
routines; the bulk of it is mainly API calls that will work in any Office
program.