PC Review


Reply
Thread Tools Rate Thread

available printers in a listbox

 
 
Corey
Guest
Posts: n/a
 
      1st Aug 2007
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 ?


 
Reply With Quote
 
 
 
 
=?Utf-8?B?Sk1C?=
Guest
Posts: n/a
 
      1st Aug 2007
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 ?
>
>
>

 
Reply With Quote
 
Gary Keramidas
Guest
Posts: n/a
 
      1st Aug 2007
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 ?
>
>



 
Reply With Quote
 
Corey
Guest
Posts: n/a
 
      1st Aug 2007
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 ?
>
>




 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Listbox to display ALL Available Printers to User on a Userfrom Corey Microsoft Excel Programming 2 12th Apr 2007 02:24 PM
Printers and Faxes Error - Unable to view Printers Installed waldoesj Windows XP Print / Fax 2 22nd Sep 2005 09:55 PM
Terminals services redirected printers vs Windows shared printers John Microsoft Windows 2000 Terminal Server Clients 3 16th Mar 2004 03:14 AM
Address-Printer (?retrofit) (direct-printers) (marking printers) vjp2@biostrategist.com Printers 0 9th Feb 2004 12:48 AM
listbox.value not equal to listbox.list(listbox.listindex,0) ARB Microsoft Excel Programming 0 22nd Oct 2003 12:46 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:04 PM.