Excel 2003 Macros not working in Excel 2016

Hi, I have over 700k excel 2007 documents on a work shared drive.

We are upgrading in a few months to Excel 2016, approx 50k of these spreadsheets have macro's and I need to know is there a tool / script that can identify all of these files that contain Macros that we can scan our network drive with.