Choose printer by Ip Address - Revisited

MrCastrovinci

New Member
Joined
Jul 27, 2010
Messages
2
All,
I have the following scenerio and I have looked high and low and can not seem to find the answer. I know others on google have asked the question however mine is slightly different.

Scenerio:
We have several hundred machines which have the same two printers installed (Plus any users printers).

What I'm looking to do:
I am looking to select the printer from the IP address not by the name since every machine operator named the printer something different.
Now from what I have read you have to call it from the printer name and port name and can't do it from the ip address. Is there a way to call it from just the port name? As every machine's port name should be the same unless the NE0x comes into play, which I have also read changes per machine. Is there a way to look at what printer is color and only print to that? I don't care what color printer (their desktop or central printer) I just need to make sure its color (for safety of results) This is automated through a macro so there won't be any intervention by the user, thus making the box to select what printer also not a good option.

:confused:
MrCastrovinci
 

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,105,943
Messages
5,508,270
Members
408,673
Latest member
CELER_

This Week's Hot Topics

Top