There are a few different ways to work with multiple printers in Excel. You can use the File > Print method, which will give you a list of all the installed printers on your computer. From there, you can select the printer you want to use. Another way is to use the
Application.ActivePrinter property. This will let you change the printer that is currently active within Excel. You can also use the
Application.Printer property to set a specific printer as the active one.
If you want to print to multiple printers at once, you can use the
Application.Dialogs(xlDialogPrinterSetup). This will bring up the Print dialog box, where you can select multiple printers. To do this, hold down the
Ctrl key while clicking on each printer you want to use. Once you have all the printers selected, click OK. Now when you go to print your document, it will be sent to all of the selected printers.
Note: If you are using a Mac computer, the process for printing to multiple printers is a bit different. Instead of using the
Application.Dialogs(xlDialogPrinterSetup), you'll need to use the
Application.CommandBars("File").Controls("Print").Execute. This will open up the Print dialog box where you can select multiple printers.