| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
COMBOBOX WITH PRINTERS LIST
Hi everyone!
I built a Form that prepares the layout of 22 sheets, but then I would like to print them (on my PC I go on the default printer) but i need to show the end-user the list of printers that he has on his computer, therefore I wanted to create a combobox with this list. Thank you in advance! Chris |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
COMBOBOX WITH PRINTERS LIST
How about just popping up the printer setup dialog?
Application.Dialogs(xlDialogPrinterSetup).Show or Application.Dialogs(xlDialogPrint).Show or if you really want to get the printers: http://google.com/groups?threadm=b23...0a% 40phx.gbl ChristianP wrote: Hi everyone! I built a Form that prepares the layout of 22 sheets, but then I would like to print them (on my PC I go on the default printer) but i need to show the end-user the list of printers that he has on his computer, therefore I wanted to create a combobox with this list. Thank you in advance! Chris -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| .AddItem list and populating combobox with created list | Excel Discussion (Misc queries) | |||
| List of available printers | New Users to Excel | |||
| How to get the available printers list in a macro | Excel Programming | |||
| Creating a printers list | Excel Programming | |||
| List of Printers | Excel Programming | |||
Hybrid Mode
