How to access different printers through form

[Kaulana]

I need to give users choice of printers to print from, but don't know how to get the information. Can get the active printer easy enough with thisprinter = application.activeprinter, but need to know how to access all the printers available to the computer without first knowing what they are. Any suggestions, please?

Kaulana (aka Bob)

http://www.bobfarley.com

 

[Kaulana]

Found the answer in an engineering forum (eng-tips, anyone ever hear of it? =]) Anyway, it's the Application.Dialogs(xlDialogPrinterSetup).Show sentence that pops up a form that shows the available printers and lets the user select the one he wants to print to. Kaulana (aka Bob)

http://www.bobfarley.com