Why did our API based utilities stop working after upgrading Data Modeler?
-First, for COM based application, both applications need to be on the same bit size. In this case Data Modeler and Excel, both should either be 64-bit or 32-bit. Note that 32 bit support for new Data Modeler releases ends in January 2021: https://community.erwin.com/t/q6h82d1/erwin-dm-32-bit-product-update
-Both EAL.dll and ERXML.dll for the current release of Data Modeler should be registered as described here: https://support.erwin.com/hc/en-us/articles/360047122951-Compile-error-when-running-the-erwin-API
-Finally, in the Excel Macros (VBA), you will need to make sure that the correct SCAPI file is selected. In Data Modeler that file is EAL.DLL. In the Visual Basic Editor....
1. Click Tools --> References
2. Validate that "erwin Data Modeler Script Client API Type Library" points to the correct location. This should be <Data Modeler Install Location>\EAL.dll
3- If the location is updated, click Run --> Reset
For any further questions, please contact erwin technical support at support.erwin.com .