Add a new Printer using IP address using the following instructios. Then use
the new printer.

1) Start button - Settings - printer and fx
2) Add printer
3) Next - Local Printer attached to this computer. Un-check automatically
detect and install my Plug and Play Printer
4) Next - Create a new Port - Standard TCP/IP Port
5) Next - Next
6) Enter IP Address For Printer in Printer Name or IP Address
7) continue responding to questions until New Printer is installed
8) Go back to excel and select the new printer.

"Larry S" wrote:

Can someone help me with a macro to print to an IP address. I have a stand
alone network printer that i want to print to and everyone has the printer
named differently on their computer. The only constant is the IP address.

Thanks in advance,
Larry