Hi
What that code will do is open all the files in the directory, and if they have links to any other files, the filename and the link reference will be put into sheet1 of the workbook containing the macro.
Once this has completed, you can search in the link references for any of the files you are chasing.
rylo
Bookmarks