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

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

Originally, this is what I used in my form (the bold part is what keeps
changing):
Application.ActivePrinter = "\\123.123.123.123\(103) LM
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) LM
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 Supply
Printer, while all else remained the same. Then people began reporting
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 to
troubleshoot the address and saw the change. I then changed the macro
to reflect the new address -- end of problem.

Just the other day, I was informed that once again, printouts weren't
appearing at Supply. I then recorded another macro and found that
*Ne04* had changed to *Ne02*. I updated the script and all was fine
until tonight. This time, the address has shifted, from *Ne02* to
*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 can
use that will always find the printer, regardless of the Ne0x?

TIA


--
AH·C
------------------------------------------------------------------------
AH·C's Profile: http://www.excelforum.com/member.php...o&userid=29108
View this thread: http://www.excelforum.com/showthread...hreadid=490684