Content Comparison

...

4. Close the VBA editor and return to your Excel workbook.

5. To run the macro, press Alt + F8 to open the "Macro" dialog, select "CheckFileNames," and click "Run."

6. Make sure to enable the correct reference.

   1. Go to References: In the VBA editor, go to Tools > References.

   2. Find and Enable "Microsoft Scripting Runtime": Scroll through the list of available references, check the box next to "Microsoft Scripting Runtime", and click OK.

Here is a video to show this in action

...