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. If you are using EXCEL 32bit, you will need to install ERwin 32bit to use this API program. if you need a download erwin 32bit application, Please visit http://erwinhelp.zendesk.com/
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.
|Definition_Comment_DT_Import_ r81.xlsm (102 kb)|
|Definition_Comment_DT_Import_ r9.xlsm (96 kb)|