View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DaveAlbany DaveAlbany is offline
external usenet poster
 
Posts: 2
Default printer port assignment in macro

I want to access a network printer via a macro and am successful as long as I
know the current address of the printer for the specific network user. The
command Application.ActivePrinter = "printername on Ne0x:" works just fine -
except the printername is different on each computer and the Ne0x: (port?)
changes from computer to computer, and in fact changes from time to time on a
single computer. How can I code this so it will work from multiple computers
all the time?