What I would like this code to do is find when a workbook has an
external link from one workbook to another. Say I have a link from
workbook A to workbook B pullnig in data from a specific range from
workbook B.


Is there away to find that the external link or name range exists in
workbook A using or modifying my code above?
Also, when workbooks are all closed and return the listing and path?

Thanks
D