Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Find links via VBA
I'm writing something that (hopefully) will scan Excel files for links. Is
there some property of the workbook object (or similar) that identifies this? Thanks. |
#2
|
|||
|
|||
Find links via VBA
FINDLINK.XLA from http://www.OALtd.co.uk/mvp already finds the places
where links are used within a single workbook. I can provide a free LinkManager program which scans a directory structure of xls files and reports on, and optionally changes to reference a different directory, all links to nominated areas of the filing system. If you want it email me at Bill_Manville at compuserve dot com. To answer your question, Excel links are found in ActiveWorkbook.LinkSources(xlExcelLinks) but be aware that hyperlinks, references in code etc. will not be picked up this way. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
#3
|
|||
|
|||
Find links via VBA
Nice utility (that's Bill's LinkManager). Looks like the end product of
what I was trying to get at. I have a couple of suggestions which I'll get back to you with. "Bill Manville" wrote in message ... FINDLINK.XLA from http://www.OALtd.co.uk/mvp already finds the places where links are used within a single workbook. I can provide a free LinkManager program which scans a directory structure of xls files and reports on, and optionally changes to reference a different directory, all links to nominated areas of the filing system. If you want it email me at Bill_Manville at compuserve dot com. To answer your question, Excel links are found in ActiveWorkbook.LinkSources(xlExcelLinks) but be aware that hyperlinks, references in code etc. will not be picked up this way. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
#4
|
|||
|
|||
Find links via VBA
Thanks Rob
I look forward to your suggestions. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I find automatic links in an Excel-sheet? | Excel Discussion (Misc queries) | |||
How to find links to another workbook? | Excel Discussion (Misc queries) | |||
how do i find which sheets contain links? | Excel Worksheet Functions | |||
can't update links...can't find links | Excel Discussion (Misc queries) | |||
How to find cells with links to other workbooks? | Excel Discussion (Misc queries) |