Printer name from handle

  • Thread starter Thread starter Eje
  • Start date Start date
E

Eje

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.
 
Perhaps you can use this. It will set the printer.

application.Dialogs(xlDialogPrinterSetup).Show
 
Back
Top