View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Papou Papou is offline
external usenet poster
 
Posts: 67
Default How do I select printer using VBA?

Hello
Application.Dialogs(xlDialogPrinterSetup).Show

HTH
Cordially
Pascal

"JS" a écrit dans le message de news:
...
I would like to set the correct printer using Visual Basic. I tried to
record
the macro with changing the printer and it shown something like this:

Excel.ActivePrinter = "My printer description"

But the problem is that I don't know the exact description of the printer
(only part of it). Is there a way how to get the list of available
printers?

Thank you