HELP please! Major problem.
I have a workbook with 9 work sheets with hundreds of hyperlinks to external
files on a networked drive.
There are multiple users.
Somehow all the hyperlinks have changed. The first 6 levels of the filepath
now points to the "C" drive of one of the users (probably the culprit!) and
is the same in every hyperlink. However, fortunately, the crucial part of the
hyperlink which points to the required file is intact.
My problem is to change the first part of the hyperlink path of ALL the
hyperlinks back to the correct file path.
I've tried 'find' and 'replace' but of course that doesn't work, I suspect I
need a macro.
I knowedge of VBA is very limited - Can anybody help with a macro or point
me in the right direction?
Any ideas how the hyperlinks could have changed en mass?
Thank you in advance.

A few people have said that this has resolved the problem for them:

File|Properties|Summary Tab|Hyperlink Base
change it to C:\
(something that's always available)

I like to use the =hyperlink() worksheet function. It has never failed me this
way:

=hyperlink("file:////yourpathtothe/something.xxx","Click me")

Ron@Buy wrote:

HELP please! Major problem.
I have a workbook with 9 work sheets with hundreds of hyperlinks to external
files on a networked drive.
There are multiple users.
Somehow all the hyperlinks have changed. The first 6 levels of the filepath
now points to the "C" drive of one of the users (probably the culprit!) and
is the same in every hyperlink. However, fortunately, the crucial part of the
hyperlink which points to the required file is intact.
My problem is to change the first part of the hyperlink path of ALL the
hyperlinks back to the correct file path.
I've tried 'find' and 'replace' but of course that doesn't work, I suspect I
need a macro.
I knowedge of VBA is very limited - Can anybody help with a macro or point
me in the right direction?
Any ideas how the hyperlinks could have changed en mass?
Thank you in advance.

--

Dave Peterson