Excel 97 VBA: Retrieve available printers?

I need to gather all available printers - any ideas?

What? No one knows?

I have no idea. Sorry. :(

i also have no idea. :(

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

------------------
jimmy
ICQ:35813919
mail:[email protected]

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?

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


For Each pr In Printers
MsgBox pr.DeviceName
Next