How do I select printer using VBA?

[Guest]

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

 

[papou]

Hello
Application.Dialogs(xlDialogPrinterSetup).Show

HTH
Cordially
Pascal

 

[Guest]

Some additional references

http://www.microsoft.com/office/com...5298&catlist=&dglist=&ptlist=&exp=&sloc=en-us