XLS files are Excel workbook files created in Excel 97 or Excel 2003. The 2007, 2010 and 2013 versions of the program use the XLSX format by default to save workbooks, but can also use the XLS format.
VBA may have a bad reputation, but it's still one of the most effective ways to automate repetitive actions in standard XLSX ...