List all link cell to other workbooks

[Grenier]

I would like to be able to list (identify) all cells in the source workbook
that have link to other workbooks ?
ex:
SourceWorkbook cell A1 link to c:\Data1.xls cell G9

vLinks = ActiveWorkbook.LinkSources(xlExcelLinks) only contain an array of
path and no detail about cell address.

Merci !

 

[Norman Jones]

Hi Grenier,

Try downloading Bill Manville's FindLinks Add-in
which may be downloaded at:

The Excel MVP Page (Office Automatiom)
http://www.oaltd.co.uk/MVP/Default.htm