C Corey Aug 1, 2007 #1 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 ?
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 ?
G Guest Aug 1, 2007 #2 I believe I used Application.Dialogs(xlDialogPrinterSetup).Show in a previous project.
G Gary Keramidas Aug 1, 2007 #3 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
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
C Corey Aug 1, 2007 #4 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
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
