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" <(E-Mail Removed)> wrote in message
news:u7oxgL%(E-Mail Removed)...
> 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
news:eor0VX%(E-Mail Removed)...
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" <(E-Mail Removed)> wrote in message
news:u7oxgL%(E-Mail Removed)...
> 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 ?
>
>