How Do I Code to print to a Printer by the Printer Name?

**rkjudy** · 12-13-2013, 05:13 PM

I have created a macro that prints to a certain printer. My problem is that the code created references the printer by NE01, NE02, NE03, etc. Because I add printers to my computer all the time, the NE number referring to this printer has changed. Therefore I get a debug error when I run this macro. My question: is there a way I can change the code to reference the printer NAME ONLY instead of having to add the NE number. This way my macro would always work regardless if I added new printers. The code is below. Thanks in advance.

Please Login or Register  to view this content.

**shg** · 12-13-2013, 05:28 PM

See http://www.cpearson.com/excel/GetPrinters.aspx

That will give you a list of printers, which you can loop through to find one like "eCopy PaperWorks Printer *"

Of, you could try Ne01, Ne02, ... until there is no error.