I have a customer who gets reports in Excel format automatically, and these files have a .xlsx extension. They utilize FileMaker to convert the information into their preferred format.

Although FileMaker supports the import of .xlsx files, it struggles to handle them unless they are first opened, saved, and closed in Excel. The only necessary action is to open the file, save it, and close it without any modifications to the data.

This procedure works when performed on Windows or when I do it on macOS. If the customer were using macOS, I could automate this process using AppleScript.

Is there a Windows-native way to accomplish this?

Askify Moderator Edited question April 27, 2023