Moving hyperlinked files to a different folder

[DJKempo]

Hello,

I have an Excel spreadsheet that has a list/table of trained employees. when I click on the employees surnames it opens a hyperlink to an individual training completion email file. The email files a stored in a folder on a shared company drive.

What I would like to do is create a number of folders (e.g., 2023, 2024, 2025) within the current folder they are stored in and then move the email files into them accordingly.

I know by doing this is I will be breaking the hyperlink, but as I have over 2000 email files and would really like to organize them better without having to update them one at a time.

Thanks

 

[Micron]

I presume you are looking for a vba solution? Easiest might be for you to have 2 columns; one with old path, the other with new path. The code linked to doesn't completely work since the OP hasn't written it correctly, but it should give you a start if you're familiar with vba. N.B. I have not done this before but the key line here seems to be the one with ChangeLink.

How to update file links in Excel using VBA

In my Excel sheet I have some files linked to it, these files are from two folders c/desktop/2022/user, c/desktop/2022/source - old folder . These files filename are in column j. Now I want to writ...

stackoverflow.com

You could assign the path values to variables as that OP did, or just make use of cell references.
HTH

 

[DJKempo]

Thanks. I'll give a go and let you know how I get on.