I have 1000's of Word documents in a folder hierarchy.




I have the NAME of a document I know for sure is referenced in one or more of the documents in the hierarchy.


How can I find these documents ?

If the link displays the name of the document, simply use a Windows search of the top folder.

Maybe I was a little too fast there ... the 'hyperlink' is an ICON I have to click on to open the document - I need to find the name of the document where that ICON is included.

If the hyperlink isn't clear text in the documents then you will probably need a macro to search through each document.

Post a sample doc that contains one of these link icons so we can work out how the code would need to work.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

You will need VBA code that traverses the folder hierarchy and opens each document in turn. The code will then need to check if there are any hyperlinks, if not close the document, then loop through the hyperlinks examining the link for the document name. I assume you will then require some form of output.

Given the quantity of documents that need to be processed it will take hours. If the folders aren't on a local disk the process will take even longer.

Is your need for the information so great that you are prepared to tie up a pc for at least a day?

In fact theWindows search CAN find it IF it's inserted as a HYPERLINK, but unfortunately I have inserted an icon that links to the document - and this can NOT be analyzed by Windows search ... and you're quiet right VBA code is running for 4-5 hours to find it !


THX to all of you for your time

Do you already have code to do this or are you still looking for code?

You need to post a sample doc with a couple of these icons so we can see what you are dealing with if you want code created.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

I made up some dirty code to do this and by chance I found the document that was 'linking' the the othe document by a icon.


I think I'll will store the code for future use IF I should need to find another document linked to by these icons.


I was looking into the possibillity in the LINKED document to make a sort of 'chain back' to the LINKING document BUT ...


I link to mails, Word documents, MP3's, videos KMZ's so I havent figured it out yet how to do that.


So I have to say "PROBLEM SOLVED" for now