Hi, hopefully a simple one.
I have created a little database in excel which creates documents and prints it to a specific printer. I got the names of the printers using the following Macro
an example of the result this would produce is: \\Server\PrinterName on Ne22:
Therefore I can put this printer in my code and it works great. However i may then come on a couple of days later, and my documents won't print. I then run the find printer macro and the 'Ne' Number has changed. I have tried to do some digging on this but couldn't find anything. Is it possible to stop this Ne number from changing? Or is it possible to get this printer into excel code without listing the Ne?
I have created a little database in excel which creates documents and prints it to a specific printer. I got the names of the printers using the following Macro
VBA Code:
Debug.Print Application.ActivePrinter
an example of the result this would produce is: \\Server\PrinterName on Ne22:
Therefore I can put this printer in my code and it works great. However i may then come on a couple of days later, and my documents won't print. I then run the find printer macro and the 'Ne' Number has changed. I have tried to do some digging on this but couldn't find anything. Is it possible to stop this Ne number from changing? Or is it possible to get this printer into excel code without listing the Ne?