how to find the available printers

[Rod]

I want to be able to find the available printers in Excel

ie the Excel equivelent to

Visio.Application.AvailablePrinters

Can't seem to find the equivalent, any help would be much appreciated.

cheers

Rod

 

[Peo Sjoblom]

Application.Dialogs(xlDialogPrinterSetup).Show

 

[Rod]

OK, that pops up a dialogue box nicely, but what I want to do is load the
printers into an array.

Sorry, I should have been more explicit.

 

[jaf]

Hi Rod,
See this API solution.
http://support.microsoft.com/default.aspx?scid=kb;en-us;166008

 

[Rod]

Thank you both