List all link cell to other workbooks
 

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 !

List all link cell to other workbooks
 

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



---
Regards.
Norman


"Grenier" wrote in message
...
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 !