When running the erwin API, you may get some variation of the below compile error.
The most common reason the API does not work is due to a mismatch in the bit level of erwin Data Modeler and excel. For example, if you have 64 bit erwin, and 32 bit excel, you will get the above compile error or a similar error when running the erwin API. To check the bit level in erwin, go to Help -> About and it should tell you whether its 32 bit or 64 bit. To check the bit level in excel, go to File -> Account -> About Excel. If the bit levels do NOT match, and you have for example 64 bit erwin and 32 bit excel, then you must either upgrade to 64 bit excel or install the 32 bit version of erwin DM instead.
If the bit levels do match and you still get compile errors, then its possible that the API components of erwin DM are not properly registered. To register the API, you just need to register the EAL.dll and ERXML.dll files. Here are the steps:
1. Open elevated command prompt.
2. Navigate to erwin install directory:
cd C:\Program Files\erwin\Data Modeler r9 ***assuming you installed to default location
3. Run the following two commands:
The following articles have more information on this error as well: