How can I change the default printer for one certain document only?

Ralph October 31, 2010
Pinterest Stumbleupon Whatsapp

I want to know if there is a way I can get one document to always print at a different printer than the usual default printer. For example, when I print an order receipt, I want that copy to go directly to the warehouse printer, not to my office one. I’m using Windows.

Ads by Google

  1. Anonymous
    November 1, 2010 at 9:41 am

    Hi
    Automatic Printer Switcher
    http://www.softpedia.com/get/System/System-Miscellaneous/Automatic-Printer-Switcher.shtml
    Automatic Printer Switcher is a powerful application designed to allow you to switch the default printer as you switch programs you are working on automatically. It sits quietly monitoring the program on top and changes the printer to the configured whenever it detects a change. . It works on Windows XP , Windows Vista, and Windows 7.

    You can configure the application and set the printer more suited to your needs. For example printing Word documents will be automatically on a N&B Laser printer and printing photos in Photoshop will be via a color printer.

    or
    ActivePrinter property of document
    http://support.microsoft.com/kb/216026

    Change the default printer using VBA in Microsoft Excel

    This example macro shows how to print a selected document to another printer then the default printer.
    This is done by changing the property Application.ActivePrinter :
    Sub PrintToAnotherPrinter()
    Dim STDprinter As String
    STDprinter = Application.ActivePrinter
    Application.ActivePrinter = "microsoft fax on fax:"
    ' change printer
    ActiveSheet.PrintOut
    ' prints the active sheet
    Application.ActivePrinter = STDprinter
    ' change back to standard printer
    End Sub