Re: Set Printing Preference (single/Double sided) with Macro

From: Jay Freedman <jay.freedman@xxxxxxxxxxx>
Date: Fri, 14 Mar 2008 19:59:14 -0400

On Fri, 14 Mar 2008 12:12:34 -0700 (PDT), McKilty <bluesbrthr@xxxxxxxxx> wrote:

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.

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit.
.

References:
- Set Printing Preference (single/Double sided) with Macro
  - From: McKilty

Prev by Date: Re: How best to distribute Excel 2003 spread*** with VBA Macros?
Next by Date: Can I use user controls in my own toolbar (Office 2003)?
Previous by thread: Set Printing Preference (single/Double sided) with Macro
Next by thread: Can I use user controls in my own toolbar (Office 2003)?
Index(es):
- Date
- Thread