Print a PDF file to a specific Printer

[Ben171]

Hi, i am wondering how to go about choosing which printer a PDF is sent to in VBA code.

I have a template which is automatically filled in through data in an excel database, which is then saved as a PDF. I then want to automatically Print this PDF. i can do this, but it sends it to the default printer.

In word it is easy because i can create and call a macro from word which changes the printer. However obviously you cannot do this for PDF's which uses Adobe as you cannot call macros

Any help would be great

Thanks