Hi,

I have a large workbook with a lot of links to different files (with
same layout).

I am looking for a way to check if the formula's in a column are all
linked to the same file or folder.
Folder would actually suit better because the filename stays the same.

Example:

C:\forecast2008\details.xls
C:\forecast2009\details.xls

Column C in workbook "summary.xls" sheet1 links to ....
2008\details.xls
Colums D links to ....2009\details

Can't find a way to use the text of the formula for comparisons.

Cheers,

Harold