• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Open & print pdf through hyperlink for a dynamic range


New Member
Hi Guys,

I currently have a massive list of PDF's in Column A, (A1 Filter, Data A2 onwards) ranging from 50-2000 (They have been hyperlinked) and I want to be able to open each document (PDF), print and close the entire list however I also want to be able to filter the list and only print the visible cells.

I don't need to visibly see each PDF open and print so I don't know if there is a way to do this in the background. I have seen a few posts about using shellExecute however this is quite unfamiliar to me.

Any help would be greatly appreciated.

Last edited: