Converting Excel to Component Interface Utility Templates to the Current Excel Version
You can use customized Excel-to-CI templates based on versions of Microsoft Excel released previous to Excel 2007. To preserve the macros embedded in your customized Excel-to-CI templates, you must convert the templates to Excel 2007 format.
Microsoft Excel 2007 files have the extension .xlsm.
To convert an Excel-to-CI template to Microsoft Excel 2007 format:
-
Open a template in Excel 2007.
-
Click the Microsoft Office Button and choose Save As.
-
Click Excel Macro-enabled Workbook.
A Save As dialog box appears.
-
Choose a save location and enter a name for the workbook.
-
The workbook name must have the extension xlsm, such as myworkbook.xlsm
-
Click the Save button.