Selecting printer address

[mtheriault2000]

Hello

I need to print either to the printer and to the a PDF printer. Since the printer address is changing on every power on, i need to found the PDF one

I got an idea to find it, but dont know how to do it

Loop trough the list of printer.
Put result in Printernameaddress
Instr(PDF, printernameadress)
next

Actually, i get the active printer when XL open.

How could i loop trought the printer list????

Martin

 

[ajetrumpet]

why can you not just set the default printer in windows? If it changes everytime you power the computer on, you might want to address that issue, rather than running a macro in excel to try and change it everytime.

 

[mtheriault2000]

Hello Ajetrumpet

I want to print to my regular printer as a reference and print to a PDF as a record file

So that's why i need to find the printer address. I want it done without my intervention, IE: automatiquely

Have a great day

Martin