Macro to create hyperlinks for multiple unique excel files in a given folder

Hello,

There was this thread a few years ago, but the macro that is posted i.e. the url doesn't exist anymore, so I have to repeat this question. I have a list of 1400 files (in one column) and I need to hyperlink it with a files in a folder (for example u_10.pdf, u_11.pdf, u_12.pdf). It would take me a long time to hyperlink it manually, so is there a macro for it that works, and also do I need to put the worksheet in the same folder where are those files which I want to hyperlink?

Thanks in advance,
Nada

="C:\file location\" & A1 & ".pdf"

Do something like this in column B and run it down the length of column.
then set a loop through column a using column b value

Please Login or Register  to view this content.