I'm currently using a VBA to extract data from MS Project into excel, using ".xls" extension. I've also, tried using ".xlsx" extensions but for some reason, MS office 2016 will not open the extracted data. I keep getting notice that the file has been corrupted. I've tried to open and repair but no luck. anyone knows of any work around?

thanks