How do I select printer using VBA?
 

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

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

How do I select printer using VBA?
 

Some additional references

http://www.microsoft.com/office/comm...xp=&sloc=en-us

"JS" wrote:

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