Printing to another printer than the default printer

[itjohan73]

So I have this excelfile where I print labels to a Zebra printer. Normally I don't have the Zebra printer as default printer because I also print other stuff on a normal printer.

Application.ActivePrinter = "Printer2 på Ne2:"

I tried this and it works, but our server keeps changing the Ne number. so it works one day.
then the next day the NE number for that printer changed. so I have to find the new number and add it.

is there a way to find the Ne number for that specific printer?
I know how to find the number, but I don't want to edit the macro each time I want to print something.

 

[sykes]

Hi and welcome to Mr. Excel!

This is an oft-asked question on this board.
May I suggest that you do a search for "NE" and "printer." A bit of leg work will throw up a who;e host of similar posts - from which you'll be able to sort out your issue.