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.

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

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

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