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.

Change the "C:\MyWorkbook1.xls" value to the desired folder path and default file name. tBook.SaveAs "C:\MyWorkbook1.xls" tExcel.Quit Click the "Save" icon on the VB6 toolbar to save the code.

If your Excel files are opening in Notepad on Windows PC, here's how you can reset the settings to make .xls, .xlsx, etc files open in Excel.