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.
