Finding broken file links on a file server

By dktracy ·
I am writing a macro that pulls in data from thousands of MS Word files on a file share. The macro gets tripped up when it comes upon a link that is broken. The only files that the macro looks at are those whose path name ends in ".doc" or ".doc.lnk". The broken links freeze the program waiting for feedback from the user on what to do with the link ("delete, fix, or cancel"). It usually ends in the "Not Responding" status in the Windows task Manager. What can I do to get around these broken links in VBA. The old On Error Resume Next doesnt work because it is waiting for a response from the operating system regarding the link.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums