I will redefine the problem according to what I have discovered.

The macro only works on the active document, if none of the documents in the folder is the active document, it does not override any of the active documents.

The problem can now be focused: What can cause VBA to not run on inactive documents?