File formats that work with Visual Basic

Which Office program are you using?

Word

PowerPoint

Excel

Word

You can create macros and then save the file in any of the following file types.

File format

Description

Word 97-2004 Template (.dot)

Saves the document as a template that you can use to start new documents. Saves document content and settings such as styles, page layout, AutoText entries, custom keyboard shortcut assignments, and menus. Compatible with Word 97 through Word 2003 for Windows and Word 98 through Word 2004 for Mac.

Word Macro-Enabled Document (.docm)

The XML-based document format that preserves VBA macro code. VBA macros run in Word 2011, but they do not run in Word 2008.

Word Macro-Enabled Template (.dotm)

Saves the document as an XML-based template that preserves VBA macro code. VBA macros run in Word 2011, but they do not run in Word 2008.

See also

Create, run, edit, or delete a macro

PowerPoint

You can create macros and then save the file in any of the following file types.

Type

What it is

PowerPoint Macro-Enabled Presentation (.pptm)

The XML-based presentation format that preserves Microsoft Visual for Basic Applications (VBA) macro code. VBA macros run in PowerPoint 2011, but they do not run in PowerPoint 2008.

PowerPoint Macro-Enabled Template (.potm)

Saves the presentation content and formatting as an XML-based template that preserves VBA macro code.  VBA macros run in PowerPoint 2011, but they do not run in PowerPoint 2008.

PowerPoint Macro-Enabled Show (.ppsm)

The XML-based presentation format that automatically opens in slide show view and preserves VBA macro code. VBA macros run in PowerPoint 2011, but they do not run in PowerPoint 2008.

PowerPoint Add-In (.ppam)

The XML-based add-in format that preserves VBA macro code. VBA macros run in PowerPoint 2011, but they do not run in PowerPoint 2008.

PowerPoint 98 - 2004 Add-In (.ppa)

Saves the add-in in a format that preserves VBA macro code. Compatible with PowerPoint 98 through PowerPoint 2004 for Mac and PowerPoint 97 through PowerPoint 2003 for Windows.

See also

Create, run, edit, or delete a macro

Excel

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 AddIn (.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.

See also

Create, run, edit, or delete a macro

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×