Hello,

I have a quandry, I am moving excel files between servers and would like to
impact assess the links in excel spreadsheet to other workbooks. The links
have for instance <drive letter:\folder name\[test.xls]Sheet1'!$A$1, if the
drive letter changed i would like to have some code which i can run against
the file which will update the links to point to the correct location. But i
also need some script which will display the link and whats it's point to.

anyone done this before? Thanks
--
The AD Designer