Create hyperlink to file in another folder if listed in column A

Hello,

I have a list of dynamic file names in column A starting row 2. What I would like is a macro that would look in another folder (for instance "C:\Temp\Data") for any of those file names (excel files) and would create a hyperlink which would open the file. Place in the link in the adjacent column F (adjacent to the file name column A). However column F contains negative numbers so I don't want to change the value of the cell in column F.

Thank you in advance for your assistance.

Hi there,

The following code will examine all values in the Range "A2:A11" of worksheet "Sheet1".

If any of those values corresponds to a filename which can be located in the folder "H:\Worksheets", a hyperlink to that file will be placed in Column "G" on the same row as the value (filename).

Please Login or Register  to view this content.

You can change any of the Const values to suit your own requirements.

Hope this helps - please let me know how you get on.

Regards,

Greg M

Thank you for your response Greg. I will test it to let you know how it works.

Hi MusicMan,

You're welcome - please do let me know if it works for you.

Regards,

Greg M

Greg,

Thanks for the code. It worked very well for me.

Hi again MusicMan,

Many thanks for your feedback - I'm glad I was able to help.

Best regards,

Greg M