Steve,
For references to external programs, you will need to set that up one time per API program. So right click in the Femap API window with that program showing, and choose "References...". Scroll down to Microsoft Excel, click the check box, and then select OK. Run the program again and...