| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a Detailed List from a Summary List | Excel Worksheet Functions | |||
| Creating A Breakout List from a Summary List | Excel Discussion (Misc queries) | |||
| Creating a List based on your choice from Another List | Excel Discussion (Misc queries) | |||
| List of available printers | New Users to Excel | |||
| List of Printers | Excel Programming | |||
Hybrid Mode
