Need to print from a specific printer on network

Try the attached file (which includes macros)
Clicking the button displays a form that lists all available printers.

That macro attempts to print a range named: PrintRange1
(to avoid conflicts with Excel's default name of Print_Area)

Is that something you can work with?

Then you might be able to use a variation of this in your printing routine:

Range(reference to the range to be printed).PrintOut ActivePrinter:=Enter the name of your printer here