I've been using for many years an Excel file with the ExecuteExcel4Macro VBA command to extract values from closed Excel files. I've used it only on a machine with Windows 7, and it has worked flawlessly. One caveat: all of my closed Excel files up to this year were .xls files.
This year, the same Excel file still correctly extracts values from every closed .xls file, but it will not extract values from any closed .xlsm files. However, when I launch any of the .xlsm files (i.e., open the Excel source files), my Excel file with the ExecuteExcel4Macro command DOES correctly extract values from the opened .xlsm files.
Anyone know why my Excel file with the VBA code still works fine on closed .xlsm files, but generates a Type 13 error for each closed .xlms file? I trap the error, report on it by putting a brief message in the output Excel file (the one with my VBA code), and then continue to read the next Excel file). Not a Dim error, as the macro works with all the data extracted when the source files are CLOSED.
One more piece of info: my Excel file with the ExecuteExcel4Macro VBA code works just fine when I run it on a Windows 10 machine. That is, it correctly extracts values from the correct cells of every one of my closed .xlsm files. So, it is only not working when: (1) I run it on my Win 7 machine, #AND# (2) the .xlms files are closed.