Macro Generated Excel Files for Workflow Upload

I have created a macro that auto-generates excel files for upload to a workflow for adjustments, however I get the following error when the file is selected for import:

This is resolved if I open and close the excel (not even necessarily saving when closing).

Has anyone encountered this error before? and aware of a solution that would streamline this need to open and close files.