B
Bill Kuunders
Our IT staff say they cannot solve the issue...............................
I use a macro to select a networked label printer as a default printer and
after the job has been printed to select the normal inkjet printer.
Problem is when we log on to the network the label printer may be on a
different port. I.e. in stead of on Ne04 it may now be on Ne01 and the
macro does not run.....
Is there a different way to select a non default printer?
Thanks
Bill Kuunders
part of the macro.................
Selection.PasteSpecial Paste:=xlValues
Application.ActivePrinter = "\\nzdfprn01\Label_UHT_Sato on Ne04:"
Sheets("label").Select
ActiveWindow.SelectedSheets.PrintOut Copies:=2
Application.ScreenUpdating = True
Application.ActivePrinter = "\\nzdfprn01\Inkjet_BevProd on Ne04:"
Sheets("schedule").Select
I use a macro to select a networked label printer as a default printer and
after the job has been printed to select the normal inkjet printer.
Problem is when we log on to the network the label printer may be on a
different port. I.e. in stead of on Ne04 it may now be on Ne01 and the
macro does not run.....
Is there a different way to select a non default printer?
Thanks
Bill Kuunders
part of the macro.................
Selection.PasteSpecial Paste:=xlValues
Application.ActivePrinter = "\\nzdfprn01\Label_UHT_Sato on Ne04:"
Sheets("label").Select
ActiveWindow.SelectedSheets.PrintOut Copies:=2
Application.ScreenUpdating = True
Application.ActivePrinter = "\\nzdfprn01\Inkjet_BevProd on Ne04:"
Sheets("schedule").Select