Help ......

I am using VBA in Excel and I have a form which I have created. On the form I need to put a drop down list box from which to select a printer.

The list of printers is not known at creation time as it is to be the list of printers installed on the current computer so that user can print to any attached printer.

Does anybody know a simple way to obtain the names for the printers that are installed. I do not want to use the xlDialogPrinterSetup as it allow the user to override my print setups.

Advise on how to populate the list box would also be helpful.

Thank you all for your help on this.