View Single Post
 
Old 01-11-2024, 06:02 AM
ksor ksor is offline Windows 10 Office 2016
Advanced Beginner
 
Join Date: Feb 2018
Location: Århus V, Denmark
Posts: 78
ksor is on a distinguished road
Smile

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