Excel: Can't Set Print Quality to Draft Through a Macro

Last reviewed: November 2, 1994
Article ID: Q57194

SUMMARY

The fifth parameter of the Print() command, draft, is reserved for compatibility with the MS-DOS version of Excel. It has no function on the Macintosh and cannot be used to specify the print quality.

A workaround is to place a Print?() command at the beginning of the macro to allow you to choose the desired print quality.

Once the print quality is set in the Print dialog box, it will apply to all subsequent macro print jobs during that session.

For more information on the Print() command, see pages 264-265 in the "Microsoft Excel: Functions and Macros" manual for version 2.20.

This is a limitation of the Macintosh System software.

KBCategory: kbother
KBSubcategory:
Additional reference words: 1.00 1.03 1.04 1.06 1.50 2.20

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 2, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.