MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Changing Printers in Excel with VBA


Posted by Tommy Golczynski on June 19, 2001 9:36 AM

I am trying to detect a list of my installed printers and provide this list to the user so they may select the output printer during a VBA macro exection. I assume there is some default command that has this information, but I do not know how to access it within VBA. I am running Excel 200, if that matters. Any help (code) to get a list of all installed printers would be greatly appreciated.


Posted by mseyf on June 19, 2001 10:25 AM

you might be able to do something with

Application.Dialogs(xlDialogPrinterSetup).Show

-Mark