 | File formats that work with Visual Basic |
You can create macros and then save the file in any of the following file types.
File format | Description |
|---|---|
Excel 97-2004 Workbook (.xls) | Compatible with Excel 98 through Excel 2004 for Mac and Excel 97 through Excel 2003 for Windows. Preserves VBA macro code and Excel 4.0 macro sheets. VBA macros do not run in Excel 2008. |
Excel 97-2004 Template (.xlt) | Saves the workbook as a template that you can use to start new workbooks. Compatible with Excel 98 through Excel 2004 for Mac and Excel 97 through Excel 2003 for Windows. Saves settings such as formatting, headings, formulas, VBA macros, and custom toolbars. VBA macros do not run in Excel 2008. |
Excel Binary Workbook (.xlsb) | Stores data in binary format. Takes less time to save, and helps keep sensitive data more secure. Preserves VBA macro code and Excel 4.0 macro sheets. VBA macros do not run in Excel 2008. |
Excel Macro-Enabled Workbook (.xlsm) | The XML-based workbook format for Microsoft Excel 2008 for Mac, Microsoft Excel for Mac 2011, and Excel 2007 and Excel 2010 for Windows that preserves VBA macro code and Excel 4.0 macro sheets. VBA macros do not run in Excel 2008. |
Excel Macro-Enabled Template (.xltm) | Saves the workbook as an XML-based template that preserves VBA macro code and Excel 4.0 macro sheets. VBA macros do not run in Excel 2008. |
Excel Add‑In (.xlam) | Saves the active sheet as an XML-based add-in, a supplemental program that runs additional code. Preserves VBA macro code and Excel 4.0 macro sheets. VBA macros do not run in Excel 2008. |
