View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones[_2_] Norman Jones[_2_] is offline
external usenet poster
 
Posts: 421
Default 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 !