I have an issue with printing an order form to one of two networ
printers (both same model). The first goes to Production contro
(never a problem there) and the second to Supply.

originally, I thot this may have been a glitch stemming from when ou
printer LAN went down last week. However, for some reason, the Suppl
printer's address keeps shifting around.

Originally, this is what I used in my form (the bold part is what keep
changing):
Application.ActivePrinter = "\\123.123.123.123\(103) L
T632 on Ne02:" 'Set & print to Production Control
ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _
"\\123.123.123.123\(103) LM T632 on Ne02:"
Collate:=True

Application.ActivePrinter = "\\123.123.123.123\(123) L
T632 on *Ne02*:" 'Set & print to Supply
ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _
"\\123.123.123.123\(123) LM T632 on *Ne02*:"
Collate:=True

At some point, last week, *Ne02* changed to *Ne04* for the Suppl
Printer, while all else remained the same. Then people began reportin
that they weren't getting a copy at Supply. I couldn't figure out why
until after a couple of days, when I decided to record a macro t
troubleshoot the address and saw the change. I then changed the macr
to reflect the new address -- end of problem.

Just the other day, I was informed that once again, printouts weren'
appearing at Supply. I then recorded another macro and found tha
*Ne04* had changed to *Ne02*. I updated the script and all was fin
until tonight. This time, the address has shifted, from *Ne02* t
*Ne03*.

Questions:
Why would this change, apparently at random?

Is it due to someone inadvertantly resetting the router perhaps?

Is there a way to lock down this Ne0x part?

Conversely, is there a method in calling out the IP address that I ca
use that will always find the printer, regardless of the Ne0x?

TI

--
AH·
-----------------------------------------------------------------------
AH·C's Profile: http://www.excelforum.com/member.php...fo&userid=2910
View this thread: http://www.excelforum.com/showthread.php?threadid=49067