For macros to work with a COM-based application, both (MS Excel and erwin DM) applications need to be on the same 32/64-bit size. Note: If you are using MS EXCEL 32bit, you will need to install erwin Data Modeler 32bit to use this API program. if you need a download erwin 32bit application, Please visit http://erwinhelp.zendesk.com, then Click 'erwin Data Modeler Solutions, Downloads and Compatibility' Button. Click the link 'All erwin Data Modeler Solutions and Patches'. On the next page, scroll down until you see the build you need.
If you are running erwin Data Modeler 64-bit, you must run MS Excel 64-bit.
the above file is for r7.3.x CA ERwin DM. Please download the attached file
Definition_Comment_DT_Import_ r81.xlsm for r8.x CA ERwin Data Modeler
Definition_Comment_DT_Import_ r9.xlsm for r9.x CA ERwin Data Modeler
Both the r7.3.x and r8.x/9 API worksheets include sample data in the Entity Definition and Attribute Definition tabs as per the screen shots above. When you go to use the API spreadsheet with you own data, you must remove the sample data first.