Hi all
I have written a macro to generate pallet labels. These labels need to be printed on specific printers as they will have self adhesive labels in the tray. The IT dept. have created these printers on the network with a specific naming of "Barcode" in the description of the printer.
As part of the user form, the user selects one of the three possible printers available. The assumption is that the user will have the printer installed but not necessarily the default printer.
The age-old problem I have encountered is around the network number (NExx) will be different for each PC the macro is run from, so therefore cannot be hard-coded into the printer string.
The question for me, is it possible using xlDialogPrinterSetup list to find the relevant printer from the list and set this as being the active printer.
I would like the code to compare the hard-coded name in the macro to compare with the xlDialogPrinterSetup list and find the correct printer.
I do not want the user to have to select the printer each time as this would be time consuming.
I know there have been a lot of posts around this, but i am struggling to find a suitable solution.
Thanks in advance
I have written a macro to generate pallet labels. These labels need to be printed on specific printers as they will have self adhesive labels in the tray. The IT dept. have created these printers on the network with a specific naming of "Barcode" in the description of the printer.
As part of the user form, the user selects one of the three possible printers available. The assumption is that the user will have the printer installed but not necessarily the default printer.
The age-old problem I have encountered is around the network number (NExx) will be different for each PC the macro is run from, so therefore cannot be hard-coded into the printer string.
The question for me, is it possible using xlDialogPrinterSetup list to find the relevant printer from the list and set this as being the active printer.
I would like the code to compare the hard-coded name in the macro to compare with the xlDialogPrinterSetup list and find the correct printer.
I do not want the user to have to select the printer each time as this would be time consuming.
I know there have been a lot of posts around this, but i am struggling to find a suitable solution.
Thanks in advance