Moving hyperlinked files

[Sharyn]

I am a teacher and I use Excel for my marksbook. I have
a folder for each subject/year group and within the
folder I have one file which is a classlist/roll linked
to individual student files and a main tasklist file.
All of the files in the folder are hyperlinked to other
files in the folder. When I begin a new semester, I
would like to copy and paste the folder to a new folder
but the hyperlinks do not update to the new location and
then have to be re-entered separately. Is there any way
to make the hyperlinks automatically update to their new
location without re-entering 150+ hyperlinks each folder?

 

[Dave Peterson]

Maybe you could use some code from David McRitchie:

http://www.mvps.org/dmcritchie/excel/buildtoc.htm
Look for: Fix Hyperlinks (#FixHyperlinks)
(a little more than half way down)

If you're new to macros, you may want to read David's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm