how to restore links automatically after server migration?

[Sabine]

We plan to migrate from Novell to Windows Server 2003, using new directory
structures. The problem is : we have more than 1000 spreadsheets which are
linked to other spreadsheets, and after the migration all the links will be
broken because of the new locations.

Is there a tool or a trick to restore these links quicker than opening all
the sheets and correct the links by hand one-by-one? I could produce a table
containing the name of the sheet, old location, new location, but then ?...

Any help is highly appreciated!

Sabine

 

[Dave Peterson]

Maybe you could use something like:

http://groups.google.com/[email protected]

Or it could give you an idea.

 

[Sabine]

Thanks a lot, it is amazing how similar our questions were! Have to try it
yet, unfortunately I am not a hero in VBA!