Trying to open multiple PDF files behind hyperlinks in Excel 2007

Hi all,

I am new here on the forum and have a problem. We are trying to create a macro in Excel 2007 where you can select multiple cells, all containing links to PDF's
There are a couple of 1000s links so i dont want to open them one at the time as I need them all.

At the moment we have the code below, but this only opens one file. Can somebody help me create it so that we can download a whole selection?
I have already searched this site but didnt come to a solution.

Thanks in advance.

Please Login or Register  to view this content.

Moderator's Note: When posting codes. Highlight the code then hit the "#" symbol to enclose it with code tags. Thanks.