I need to use my computer name to select a printer

This is by no means ready to use, but meant to present the "makings" of a working approach, to give you a reasonable starting point to working out the rest.

Please Login or Register  to view this content.

Hello maclevey

You can invoke the system dialog to let the user select any printer installed on the user's machine with this line of code...

Please Login or Register  to view this content.

Right, in the code suggested in post #2, we are using that approach for any USERNAME the macro doesn't accurately detect the username to allow the user to select the printer on the fly.

Hello maclevey,

Here is a method that uses the WMI to return the names of installed printers. It can also return more information about each printer if you need it like if it is the default, it's location, etc.

The function returns the printer names in a scalar zero based array. This can be loaded into a ListBox's or ComboBox's List property directly.

Please Login or Register  to view this content.

Maclevey, if these suggestions give you what you need to complete your task, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.