printing pdf files using vba in excel

[eddie1980]

hi, i am trying to create a macro that automatically opens, then prints a pdf object from within a excel spreadsheet. i can open the file but i cannot manage to get it to print, can anybody help, pleeeeeease!!

 

[HaHoBe]

Hi, eddie1980,

depends on how you ant to approach: either just change the printer for the output (try recording a macro by going through this process) or maybe use ShellExecute and the Acrobat Reader (if the file is already present on the PC).

Ciao,
Holger