Excel 97 VBA: Retrieve available printers?

[coox]

I need to gather all available printers - any ideas?

[coox]

What? No one knows?

[billwagnon]

I have no idea. Sorry.

[Howard Stern]

i also have no idea.

[jimdalby]

do u mean ALL available printers, like ones over networks and stuff, or only local ones??

------------------
jimmy
ICQ:35813919
mail:jim@rdalby.f9.co.uk

[coox]

Jim, all printers available from a given machine, ie all the ones you can see when you go into print setup or whatever (including fax drivers and all that crap). I think I should get a prize for asking a question that no one (so far) can answer, eh?

[vbehyr]

I don't use Excel but this is how to do it in vb.


For Each pr In Printers
MsgBox pr.DeviceName
Next