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:

  1. Open a template in Excel 2007.

  2. Click the Microsoft Office Button and choose Save As.

  3. Click Excel Macro-enabled Workbook.

    A Save As dialog box appears.

  4. Choose a save location and enter a name for the workbook.

  5. The workbook name must have the extension xlsm, such as myworkbook.xlsm

  6. Click the Save button.