Creating a printers list
 

Hi,

I can use Application.Activeprinter to get or set the activeprinter.
How do i get ALL available printers (I want to load them into a ComboBox on
an Userform)?

TIA
PO

Creating a printers list
 

Hi Po

That takes some Windows programming, and the solution depends on your
operating system. See Randy Birch's code
http://www.mvps.org/vbnet/index.html...umprinters.htm

--
HTH. Best wishes Harald
Followup to newsgroup only please

"PO" <po skrev i melding ...
Hi,

I can use Application.Activeprinter to get or set the activeprinter.
How do i get ALL available printers (I want to load them into a ComboBox
on
an Userform)?

TIA
PO

Creating a printers list
 

If your main purpose is to allow the user to change the printer, why not use
the built in capability:

application.Dialogs(xlDialogPrinterSetup).Show
--
Regards,
Tom Ogilvy

"PO" <po wrote in message ...
Hi,

I can use Application.Activeprinter to get or set the activeprinter.
How do i get ALL available printers (I want to load them into a ComboBox
on
an Userform)?

TIA
PO