Renaming folders and changing links accordingly

[fullers]

Not sure if this is the right place to post this question but I will give it
a go.

I work in a fairly large office with a shared drive where we all save
spreadsheets and they all link to each other. Some bright spark years ago
decided to name one of the main folders after the manager at the time. Now a
new manager has taken over and naturally wants to get rid of the reference to
the old one.

Unfortunately there are hundreds upon thousands of spreadsheets within this
folder, as well as hundreds upon thousands of sub folders. The current folder
is called "Business Solutions - PJS" with the initials being the manager's
initials.

Can I write a macro (or anything) that will go through and change the links
to just "Business Solutions" after we rename the folder.

Really hoping somebody can help otherwise it is going to be rather time
consuming.

[Bob Phillips]

I haven't used this utility myself, but Bill Manville has written a links
utility called FindLink. You can get it at
http://www.oaltd.co.uk/MVP/Default.htm.

This is the bit that might help you ... Optionally the utility will list
the occurrences, list and delete (replacing with values where appropriate),
or ask you what to do with each occurrence

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"fullers" <fullers@discussions.microsoft.com> wrote in message
news:423E780D-8965-4C40-8CCA-E8A68D2C24EF@microsoft.com...
> Not sure if this is the right place to post this question but I will give
it
> a go.
>
> I work in a fairly large office with a shared drive where we all save
> spreadsheets and they all link to each other. Some bright spark years ago
> decided to name one of the main folders after the manager at the time. Now
a
> new manager has taken over and naturally wants to get rid of the reference
to
> the old one.
>
> Unfortunately there are hundreds upon thousands of spreadsheets within
this
> folder, as well as hundreds upon thousands of sub folders. The current
folder
> is called "Business Solutions - PJS" with the initials being the manager's
> initials.
>
> Can I write a macro (or anything) that will go through and change the
links
> to just "Business Solutions" after we rename the folder.
>
> Really hoping somebody can help otherwise it is going to be rather time
> consuming.
>