External Links From Spreadsheet

[TopJack]

Any ideas or direction would be much appreciated.

I need to search through 100's of Excel spreadsheets and identify what files have links (from cells, ie formula) and to where ?

So far if I open a spreadsheet I can use the following statement to find potential links.

link_array = ActiveWorkbook.LinkSources 'find all document links

But its difficult to automate this search because I need to open every individual spreadsheet.

Any clues would be helpfull.

 

[BrainB]

something like (?):-

'-------------------------------------------
For Each ws In ActiveWorkbook.Worksheets
MsgBox (ws.Name)
Next
'-------------------------------------------

Links have always been a problem. Some notes :-
1. Can search for Links in worksheets. They all contain "[".
2. Watch out for links in named ranges.
3. Microsoft have a free download addin that replaces links (FINDLINK.XLA I think). Regards
BrianB
** Let us know if you get something that works !
================================