Choosing Printer from dialog but not printing to it

[lesotho72]

Hello,

I would like to allow a user to select a printer from the Printer dialog. Then, I will save their selection so I may use it in future steps to print to that printer.
Note, I do not want the user to print to that printer after it is selected. I need to save the value of selected printer.
I can use this but it prints and does not save the name of the printer:

Application.Dialogs(xlDialogPrint).Show

Is there any way to just save the name of the selected printer selected in the line of code above? I am trying to set a variable = to this but it only returns true/false. i.e.

selectedPrinter = Application.Dialogs(xlDialogPrint).Show

Any help greatly appreciated!


Thanks,
Dan

 

[jaslake]

Hi Dan

This link gives me some ideas...see if it does the same for youhttp://www.mrexcel.com/forum/showthread.php?t=79535

John

 

[shg]

The dialog give you the opportunity to select a printer and then press Close.

After that,

sPrinter = Application.ActivePrinter