Display available printers with vba
Posted by Josh on January 26, 2002 5:39 PM
I have several charts which are on a hidden sheet in excel and I show the charts on a userform. I have a button set up to print and it works fine, but what if the user has a couple of printers and they dont want to use the defauls printer. Is there a way to get the list of available printers on the users PC. Display them and then let the user choose one, then print to that printer?