Hello,
I need to remove hyperlinks from many documents at once. I've found VBA code called "KillTheHyperlinks" in several places online, but it doesn't work for me. There are two versions of that code--to kill hyperlinks in the current document, which didn't work; and to kill hyperlinks in all currently open documents. I want to run this on sometimes hundreds of files at once, so that wouldn't be very efficient for me either.
I think the solution might be in something like field.unlink? I've taken a beginner VBA class, but it's been a long time. I'm not sure how to unlink every field using VBA.
Currently, I am removing the hyperlinks by opening each document, typing ctrl-a, and then ctrl-shift-F9. There are other things I need to do to each document, but I think I've found ways to automate all of them--except for removing the hyperlinks.
I found this bit of VBA to do find and replace for multiple documents at once (
https://www.extendoffice.com/documen...ple-files.html), and it works beautifully. I still need to figure out how to do multiple finds and replaces at once. I know someone posted a way deeper into that thread.
The last thing I need to do is remove the metadata. I found some freeware called Metadata Cleaner that I'm planning to download--but if there were a vba method, that would be even better.
But that's not what this thread is about, so primarily, I need to know how to remove the hyperlinks in many documents at once.
Help??
Thanks in advance!