Naming network printers in VBA

M

Merlin

I have an Excel workbook that is used on multiple workstations that I want to
print using a specific print driver on a network printer. When I record the
macro and choose the printer it adds the server path and "Ne12" to the end of
the printer name ie "\\servername\RICOH Aficio MP C2500 PCL 5c Color on
Ne12:" Unfortunately onther workstations don't recognize the "Ne12", and I
get a runtime error. If I record the macro on another worksation it might
call it "\\servername\RICOH Aficio MP C2500 PCL 5c Color on Ne05:". Is there
some way for all workstations to see the print drivers the same? I can't use
the printer IP address cuz that would not specify the driver name.
Any ideas? Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top