File Extensions

What is the difference with the following three extensions/TYPE?

Excel Macro-Enabled Workbook

Excel Macro-Enabled Template

Excel Binary Workbook

Hi,

1. Spreadsheet .xls
Main spreadsheet format which holds data in worksheets, Charts, and macros

2. Excel Workbook .xlsx
The default Excel 2007 workbook format. In reality a ZIP
compressed archive with a directory structure of XML text
documents. Functions as the primary replacement for the
former binary .xls format, although it does not support
Excel macros for security reasons.

3. Excel Macro-Enabled Workbook .xlsm
As Excel Workbook, but with macro support.

4. Excel Binary Workbook .xlsb
As Excel Macro-enabled Workbook, but storing information in
binary form rather than XML documents for opening and saving
documents more quickly and efficiently. Intended especially
for very large documents with tens of thousands of rows,
and/or several hundreds of columns

See these two links for more details
-- http://wiki.scn.sap.com/wiki/display...LS,.XLSM,.XLSX
-- http://en.wikipedia.org/wiki/Microsoft_Excel

From the Excel help file:

	A	B	C
1	Excel Workbook	.xlsx	The default XML-based file format for Excel 2010 and Excel 2007. Cannot store Microsoft Visual Basic for Applications (VBA) macro code or Microsoft Office Excel 4.0 macro sheets (.xlm).
2	Excel Workbook (code)	.xlsm	The XML-based and macro-enabled file format for Excel 2010 and Excel 2007. Stores VBA macro code or Excel 4.0 macro sheets (.xlm).
3	Excel Binary Workbook	.xlsb	The binary file format (BIFF12) for Excel 2010 and Excel 2007.
4	Template	.xltx	The default file format for an Excel template for Excel 2010 and Excel 2007. Cannot store VBA macro code or Excel 4.0 macro sheets (.xlm).
5	Template (code)	.xltm	The macro-enabled file format for an Excel template Excel 2010 and Excel 2007. Stores VBA macro code or Excel 4.0 macro sheets (.xlm).
6	Excel 97- Excel 2003 Workbook	.xls	The Excel 97 - Excel 2003 Binary file format (BIFF8).
7	Excel 97- Excel 2003 Template	.xlt	The Excel 97 - Excel 2003 Binary file format (BIFF8) for an Excel template.
8	Microsoft Excel 5.0/95 Workbook	.xls	The Excel 5.0/95 Binary file format (BIFF5).
9	XML Spreadsheet 2003	.xml	XML Spreadsheet 2003 file format (XMLSS).
10	XML Data	.xml	XML Data format.
11	Excel Add-In	.xlam	The XML-based and macro-enabled Add-In format for Excel 2010 and Excel 2007. An Add-In is a supplemental program that is designed to run additional code. Supports the use of VBA projects and Excel 4.0 macro sheets (.xlm).
12	Excel 97-2003 Add-In	.xla	The Excel 97-2003 Add-In, a supplemental program that is designed to run additional code. Supports the use of VBA projects.
13	Excel 4.0 Workbook	.xlw	An Excel 4.0 file format that saves only worksheets, chart sheets, and macro sheets. You can open a workbook in this file format in Excel 2010, but you cannot save an Excel file to this file format.

Thanks for the feedback