Selecting a printer

[rhino4eva]

Is it possible to use VBA macros to select a printer form a list of 3
I have 3 printers available on my network
The default printer keeps switching to one that I don't require.
When I run a printout macro how do I tell it which printer use if its not the default

 

[NdNoviceHlp]

Hi rhino4eva. HTH. Stay safe. Dave

[SOLVED:] Finding/Changing Default Printer

I'm trying to code for the user to set thedefault printer only once per session. Using the dialog code... Prt = Application.Dialogs(xlDialogPrinterSetup).Show Works okay with XL2016 however with XL97 the sheet with print previewscreen is displayed after the dialog. This XL application is...

www.vbaexpress.com