| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printer name from handle
I need the printer name to printout an Excel worksheet.
CommonDlg returns a handle to the chosen printer while the printout command needs the printername. The "newer" PrinterDlg may return the printername but instead needs a handle to a window. What window is unclear. User32.dll can return a window's handle but need a frameclass which a can't find. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Printer name from handle
Perhaps you can use this. It will set the printer.
application.Dialogs(xlDialogPrinterSetup).Show -- Regards, Tom Ogilvy "Eje" wrote in message ... I need the printer name to printout an Excel worksheet. CommonDlg returns a handle to the chosen printer while the printout command needs the printername. The "newer" PrinterDlg may return the printername but instead needs a handle to a window. What window is unclear. User32.dll can return a window's handle but need a frameclass which a can't find. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Printer name from handle
Many thanks, Tom. You gave me an accepable solution.
Eje -----Original Message----- Perhaps you can use this. It will set the printer. application.Dialogs(xlDialogPrinterSetup).Show -- Regards, Tom Ogilvy "Eje" wrote in message ... I need the printer name to printout an Excel worksheet. CommonDlg returns a handle to the chosen printer while the printout command needs the printername. The "newer" PrinterDlg may return the printername but instead needs a handle to a window. What window is unclear. User32.dll can return a window's handle but need a frameclass which a can't find. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to handle something like this | Excel Discussion (Misc queries) | |||
| what is "fill handle". i don't see any fill handle in my excel | New Users to Excel | |||
| members on my network printer not able to print to default printer | Excel Discussion (Misc queries) | |||
| Printer Multiple Worksheets with a particular Printer Setting | Excel Worksheet Functions | |||
| Fill handle turned into a move handle | Excel Discussion (Misc queries) | |||
Linear Mode
