Hi All,

Thank you for checking in. I'm kind of new to this whole VBA programming thing so I was hoping to get some help on this Macro I'm trying to build. Basically, I have a table (see below) with names of certain securities in Column A, their corresponding hyperlinks in column B, whether the hyperlinks need a password to be accessed in Column C, the month in column D, Year in column E, save location in column F, and example directories of where the .pdf files located within the hyperlinks should be saving to in column G. And, I'm trying to create a macro that will go through the hyperlinks in Column C and save the files that the hyperlinks leads to to the respective directories in column F under the Save Name indicated in Column G.

I have attached an example of the table below:
Example File.xlsx

I've dabbled with the code a bit, but can't seem to get it to work. Can someone please provide a hand or an example? Please let me know if there is any other way I can clarify.

Thank you!

Vasilis