Cannot store VBA macro code or Excel 4.0 macro sheets (.xlm). The default file format for an Excel template for Excel 2010 and Excel 2007. The binary file format (BIFF12) for Excel 2010 and Excel 2007.
Stores VBA macro code or Excel 4.0 macro sheets (.xlm). The XML-based and macro-enabled file format for Excel 2016, Excel 2013, Excel 2010, and Excel 2007. Cannot store Microsoft Visual Basic for Applications (VBA) macro code or Microsoft Office Excel 4.0 macro sheets (.xlm). The default XML-based file format for Excel 2010 and Excel 2007.
However, you also have the option to continue to work in Compatibility Mode, which retains the original file format for backward compatibility. To take advantage of the new features of Excel 2010, you can save the workbook to an Excel 2010 file format. If you open an Excel 97-2003 workbook, it automatically opens in Compatibility Mode. To open a file that was created in another file format, either in an earlier version of Excel or in another program, click File > Open. Note: Whenever you save a file in another file format, some of its formatting, data, and features might not be transferred.
0 kommentar(er)
