Need to do mass changes to excel 2003 documents. These current hyperlinks point to \\server\dir1\dir2\dir3\filename.???
need to change the portion "\\server\dir1\" to "N:\"
saw many macros and vb code that have worked (apparently) but i've had no such luck. Even found one thread that prompted the user for the before and after while keeping track of how many it found and changed. This one counted 187 hyperlinks but fixed none.