Julie D

It varies from worksheet to worksheet .. but if you could sendme the root
macro I would be able to modfiy it accordingly - please advise

is my email

"JulieD" wrote:

Hi

i've recently written a macro to deal with a workbook with 300+ hyperlinks
when the IT dept renamed the folders on the server (sweet people) ... if
you'ld like to give me an example of the wrong address and the right address
i might be able to modify it to work for you.

Cheers
JulieD

"mmekennedy" wrote in message
...
These are hyperlinks (file pointers to documents in a folder on the
network)
- edit - link does not work in this instance - any other
ideas\suggestions?

"Bill Manville" wrote:

Mmekennedy wrote:
Ii have an excel file that was corrupted and restored and now that i
placed
it back in the original folder 100's of links are wrong and point to
restored
folder ... is there a way to get the links to point to the correct
path vs
the restore path?


If you have links to a few files, Edit / Links / Change Source
If you have links to 100s of files, you could try my LinkManager.
(It is designed to change links in many files, but could probably be
persuaded
to do just the one).

If Edit / Links is too daunting, email me at Bill_Manville @
compuserve.com
(without the spaces) for a copy of LinkManager

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup