General discussion

  • Creator
    Topic
  • #2079524

    Duplexing Excel 5.0/95/97

    Locked

    by srobertson ·

    I need to be able to force Excel worksheets to print duplex without the need to change the printer set-up whenever the workbook is closed and re-opened (Particluarly in different domains).

    A VBA solution would assist as most of the printing is completed through a series of VBA modules.

    This is possible in Word 6.0/95/97 using PCL commands within the Print Field, however I’be been unable to locate an Excel equivalent and I am unable to directly change the printer configuration from Excel.

All Comments

  • Author
    Replies
    • #3775239

      Duplexing Excel 5.0/95/97

      by tclere ·

      In reply to Duplexing Excel 5.0/95/97

      I am not sure how to change the printer configuration, but you may be able to work this in to your application.

      ActiveWindow.SelectedSheets.PrintOut Copies:=2

      • #3773042

        Duplexing Excel 5.0/95/97

        by srobertson ·

        In reply to Duplexing Excel 5.0/95/97

        There’s no problem with the number of copies being produced but rather I need to be be able to force double sided printing with user input or interferance.

        Thank you for your response.

Viewing 0 reply threads