Hi All,
I made the mistake of creating hyperlinks to files on a server (using the \\SERVERNAME convention) without using the "hyperlink base" option.
I've been sufficiently chastened, but the present problem is that I have many such hyperlinks that are now worthless because, when saved, they point to "../../[foldername1]/[foldername2]/[filename]", etc.
Can anyone help me with a macro that would replace the first five characters ("../..") of all the hyperlinks on my sheet with //[MYSERVERNAME] ?
Or is there a way to do this w/o having to program?
Thanks in advance
Bookmarks