using a macro to select different printers

[iwiman]

I have one last issue with my visitor management workbook that I have created and it is this:

When the macro is ran, the macro copies the information in the userform to 3 other worksheets. One of the worksheets is set up to look like a label and currently it prints the label to the dymo label printer which is the default printer so I have the code for that. The issue is that the next sheet is a vehicle pass which needs to be printed to the color printer in the office. Can code be written so that excel then switches the printer to the color printer and prints the vehicle pass and then switches pack to the default printer so that the next person that starts the userform to log in a visitor will get the correct results and the right documents sent to the right printer?

If you could help I would appreciate it. The printer names are:

DYMO LabelWriter 450
MU_CP2025_Color

The label prints to the dymo label printer and the vehicle pass prints to the Color printer.

[Leith Ross]

Hello iwiman,

Application.Active printer either returns or sets the printer. Check the code below to be sure I have switched the printers correctly for the sheets. I have marked the added line in bold text. Make similar changes to your buttons as needed.

Please Login or Register  to view this content.