Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,275

    change Printer With vba code

    someone point in the right place please
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE

  2. #2
    Join Date
    Apr 2004
    Location
    Derbyshire, UK
    Posts
    755
    Hi

    Hint - try recording a macro and change the printer.

    It should look something like

    Application.ActivePrinter = "\\BFMANSFIELD\Xerox Phaser 8200DP on Ne02:"


    If you want to change the printer back in code then

    Dim CurrentPrinter as string

    CurrentPrinter=Application.ActivePrinter

    Application.ActivePrinter = "\\BFMANSFIELD\Xerox Phaser 8200DP on Ne02:"


    'DO YOUR PRINTING HEAR

    Application.ActivePrinter=CurrentPrinter


    or similar


    MTB

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •