Hyperlink Problem

[nuge725]

Hello everybody, I hope someone can help me with this. I am working on a file at work, which has a hyperlink for each day of the year to a different file. The problem I am having is that my hyperlinks no longer work (yet they did before), and it seems that when I change them, save, and reopen the file...it reverts back to a wrong address. For example, if the hyperlink to the file is Network Drive\Folder 1\Folder 2\Folder 3\Folder 4\Folder 5\Aug\Day (16).xls - it will change itself to Network Drive\Folder 1\Folder 2\Folder 3\Folder 4\Folder 1\Folder 2\Folder 3\Folder 4\Folder 5\Aug\Day (16).xls

I would like to know if there is a simple way to change all of these, so I don't have to do it manually 365 times. Also, does anyone know how to keep the link from reverting back? Thanks in advance for any help you can give.

Ryan

 

[cplusHR]

Have you tired to use Marco to revert.

 

[nuge725]

No I haven't...and I'm fairly new to VBA/Macros, so I don't completely know what I'm doing there - still learning.