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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

active printer 2
Change to different active printers on different PC's 3
Printing problems (need answer from Jeffrey Tan[MSFT]) 0
Multiple instances of printer created... 7
Hide the Name Box 3
How to read settings from xlDialogPrint 1
Strings and Escape Characters 7
How to print only certain page(s) in Microsoft Reports rdlc 0

Back
Top