View Single Post
 
Old 01-11-2024, 04:51 AM
Italophile Italophile is online now Windows 11 Office 2021
Expert
 
Join Date: Mar 2022
Posts: 341
Italophile is just really niceItalophile is just really niceItalophile is just really niceItalophile is just really nice
Default

Quote:
Originally Posted by ksor View Post
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 ?
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?
Reply With Quote