When running an API you get the following error:
Can't find project or library.
To overcome that error, in the VBA window, go to Run - Reset. Then go to Tools - References.
Please find the item that has MISSING in front of it.
It will be missing the CA Erwin Data Modeler Script Client API Type Library or similar.
Uncheck the box in front of it and do a Browse. Go to C:\Program Files\erwin\Data Modeler r9 and double click on EAL.dll.
Then press OK to leave that menu and try running VBA again. It should now be successful.