Print PDF File from Hyperlink

[plwhittington]

I have an worksheet with hyperlinks to .PDF files locally on my computer. My macro can open the files without any problem, but is it possible to print the files using an Excel macro? I would like to be able to select all, many, or one of the files to print.

Thanks.

 

[McQuinge]

I'm having the same challenge! I use a filter so I just see the links to the documents I need. And without any answer to this problem I have to open each hyperlink and print. I tested out some weird solution with showing the sheet in IE. From IE there is an option to print sheet with link content. But the result was that IE ignored my filter and started printing out all my documents.

So anyone, please help us!