I am trying to note down what documents have external links in them.
I have written a macro that opens and closes all documents in a folder. I wait for the message to pop up saying this documents has links. I then press ctrl + break to break to code and check what document it is, I then write down the name of the document and press F5 to continue. This works but it is slow and tedious when i have 1000s of documents to check and I have to pay attention to it.
Anyone know another way of checking documents for external links so I don't have to use the popup? I have tried using On Error Go to etc but Excel doesn't see the update links message as a error.
If anyone knows of any other ways that would be much appreciated.