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 / s...