Is there a simple way to have a form show all available printers in a listbox, and a user to simply
select one to print to it ?

I believe I used
Application.Dialogs(xlDialogPrinterSetup).Show
in a previous project.



"Corey" wrote:

Is there a simple way to have a form show all available printers in a listbox, and a user to simply
select one to print to it ?

just use something like this, it's much easier

dim bOK as string

bOK = Application.Dialogs(xlDialogPrinterSetup).Show 'choose the printer
If bOK = False Then exit sub

--


Gary


"Corey" wrote in message
...
Is there a simple way to have a form show all available printers in a listbox,
and a user to simply
select one to print to it ?

perfect thanks



"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
just use something like this, it's much easier

dim bOK as string

bOK = Application.Dialogs(xlDialogPrinterSetup).Show 'choose the printer
If bOK = False Then exit sub

--


Gary


"Corey" wrote in message
...
Is there a simple way to have a form show all available printers in a listbox,
and a user to simply
select one to print to it ?