This is a simple trick but really tricky one.
@ your Edit: By default, all Excel files are saved with the extension .xls, so you don't have to change the extension when you save the copy.
Hi, I have the following VBA script that works perfectly. But it saves the file as an XLS file and I need it to save as an XLSX. ). In the Save as type list, click the file format you want. In the VBA code I want to save the same file as xlsx and email. As you work in Microsoft Excel 2010, remember to save your work often or you risk losing your data if the computer crashes or the power goes out. Note that existing workbook will continue to use its existing file format to save. Important: If you want to keep an Excel version of your file, you need to save the file as an Excel worksheet, for example in the .xlsx file format, and then save it again in the OpenDocument … This thread is locked. The Save As dialog will display, specify a folder to place the new format of the file, and then click Save as type drop down list to choose Excel 97-2003 Workbook. File1 will still be in the location that you last saved it. Click File > Save As. Follow these steps: Click File > Info > Check for Issues. if I try to save it as xlsx, it does get saved but when I open it, it gives Click Save. To verify that a workbook is compatible with Excel 2013, 2010, or 2007, run the Compatibility Checker manually the first time you save your workbook. This is why I want to ask you which ideas you have about it. To make Excel 2010 always save in Excel 97-2003 format, on File click Options. That said, unless you collaborate extensively with users of MS Office, editing each other's files, I must agree with previous respondents that it is always a bad idea to use MS formats in OpenOffice. Now click OK to always save it in XLS format. The second example use GetSaveAsFilename to ask you for a file path/name. I have a xslm file. Excel 2007 and Excel 2010 will now automatically use .XLS file type on “Save As” dialog box when user attempts to save a new workbook. instead of XLS, thus making them unrecognizable to EXCEL 2010. this even happens when I save/update a 2010 file. Under the “Save workbooks” section, select Excel 97 – 2003 Workbook from the Save files in this format drop down list. The appearance and functionality of the Save As dialog box […] It will open Excel Options dialog, from left sidebar, select Save and from main window under Save workbooks section, from Save files in this format list, select Excel 97-2003 Workbook. For these individuals, a better solution would be to save to the xls file format by default in Excel 2010, ensuring that you do not accidentally create a file that cannot be opened by people using Excel 2003 or earlier.