Finding the printer port
I have searched high and low for this...help!
I have a macro that prints to Adobe Distiller from excel and then converts to PDF. My problem is Distiller is not the default printer. The macro changes the default to Adobe Distiller but that line of code is fixed.
Application.ActivePrinter = "Acrobat Distiller on Ne04:"
At the end of running, the macro reassigns the default printer.
The problem occurs when another user tries to run the macro. Is there any way to have the code determine the port of Distiller automatically? All the code I have found does not seem to do what I need it to do.
Video Tutorials / Excel Dashboards Reports