Re: Print macros

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Daniel Louwrens (flint_dlouwrens_at_nospambigpond.com)
Date: 06/02/04 

Date: Wed, 2 Jun 2004 10:57:19 +1000

Hi Joe - As you have specified the printer to print you need to again
re-select your default printer using the same code:
ie - Application.ActivePrinter = "Win2PDF on Ne00:"
    ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _
        "Win2PDF on Ne00:", Collate:=True
're set to correct laser printer
On Error GoTo printererror
Application.ActivePrinter = "\\NSWNT1\HPLaserJet on Ne02:"

The error routine is this case is it's a network printer so it may not be
found - hope this helps - Phil

"Joe" <anonymous@discussions.microsoft.com> wrote in message
news:F88905AA-F8BA-4FED-B9D5-6C19040A60A3@microsoft.com...
> Hi all,
>
> I have created a print macro in word that selects a
> specific printer so I can print double sided, but when I
> do this windows changes the default printer to the printer
> that is used for double sided printing. I want the macros
> to select the printer for double sided printing and when
> its been printed, revert back to the default printer. Can
> anyone help me out pls?
>
> Thanks,
>
> Joe
>

Quantcast