Thread: Print to PDF

Hi there i have this piece of code:

    Application.ActivePrinter = "Adobe PDF on Ne02:"
    ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _
    "Adobe PDF on Ne02:", Collate:=True

This prints my excel document to pdf fine on Ne02. The problem i have is when the document is printed to pdf on a different pc the Ne is Ne04 or Ne03 so its different on each pc.

Is there a way the above code can be altered so it will print on any Ne02 or have the code search for which port Adobe PDF is installed on and print to that port so i dont have to have multiple sets of code.

Thanks.