Network Printer 'ActivePrinter' of object'_Application' failed

  • Hello
    I am having trouble printing a page to both a local printer (which works fine) and a network printer (which does not work)
    Both printers are installed on the Computers.
    The error message I get when I try to run the macro is
    Run-Time ERror '1004':
    'ActivePrinter' of object'_Application' failed.


    The codes that I have used are

    Code
    1. Application.ActivePrinter = _
    2. "\\SAUWTPFS01.sopac.pilkington.net\Despatch Toughend & Batch reports (L164) on Ne05:"


    and

    Code
    1. Application.ActivePrinter = _
    2. " \\sauwtpfs01\pauwtp0305 on Ne05:"

    and

    Code
    1. Application.ActivePrinter = _
    2. " \\sauwtpfs01\pauwtp0305"


    It works on the day I record the macro. As soon as the next day comes around I get the error message.


    When I click debug it is these lines that are highlighted in yellow. I have looked at this for several days on and off and I always get the same error.


    Your assistance is greatly appreciated...


    Thanks

    :) Help me please... :)

  • Re: Network Printer


    Althausar,


    We use code tags around VBA in the forum like a foundational religious belief. I have added them for you here; please be mindful in the future.

    [SIZE=1]Entia non sunt multiplicanda sine necessitate.[/SIZE]

  • Re: Network Printer


    Does the Ne05: part of the reference change at all?


    I'm not sure whether the assignment for net port is a static thing or variable everytime you restart the pc.

    [h4]Cheers
    Andy
    [/h4]

  • Re: Network Printer


    Try not to get to involved in UNC to full DOS paths, this is a part of a procedure Jack wrote and I use every day, Jack wont post all the codes as is very complex and involves CLASS files coupled with events, this will help

  • Re: Network Printer


    Quote from Andy Pope

    Does the Ne05: part of the reference change at all?


    I'm not sure whether the assignment for net port is a static thing or variable everytime you restart the pc.


    The NE05 does change. I recorded a new macro yesterday and it came up with NE02


    Even our IT guys are stumped... But I might try to see if they know about this NE## changing. :)

    :) Help me please... :)