Save Workbook In Another File Format. When Excel saves a workbook to one of the CSV or text formats. Pick the place where you want to save the workbook.
Click File Save As. I have numerous occasions to save a copy of a workbook in a different file format xlsX and keep the main wb open xlsM using a macro. Sub Save Dim nameFile as String Dim pathDest as String nameFile Cells 2 18Value pathDest ThisWorkbookPath ThisWorkbookSaveCopyAs pathDest nameFile xlsx End Sub.
XML Spreadsheet 2003.
Excel 40 Workbook. Example 1 you can use in Excel 97-2016 Example 2 you can use in Excel 2000-2016. Class Libraries REST APIs for the developers to manipulate process Files from Word Excel PowerPoint Visio PDF CAD several other categories in Web Desktop or Mobile apps. If not specified missing the workbook will be saved to the workbooks underlying file which is the file specified in loadWorkbook also see the workbook class for more information.