Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to link the content of a cell with a related list of items | Excel Worksheet Functions | |||
LINK ONE CELL TO AN ENTIRE LIST | Excel Programming | |||
I WANT DATA TO LINK WITH OTHER WORKBOOKS ACORDING TO CELL CONTENT. | Excel Worksheet Functions | |||
Link Workbooks | Excel Discussion (Misc queries) | |||
How can I link one cell to a list of info in another workbook? | Excel Discussion (Misc queries) |