title: ExecuteExcel4Macro now only works when .xlms source files are open
body: <p>I've been using for many years an Excel file with the <code>ExecuteExcel4Macro</code> 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.</p>
  <p>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 <code>ExecuteExcel4Macro</code> command DOES correctly extract values from the opened .xlsm files.</p>
  <p>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.</p>
  <p>One more piece of info: my Excel file with the <code>ExecuteExcel4Macro</code> 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.</p>