Compile error can't find project or library while using functions from Spreadsheet Link Ex

When I open Microsoft Excel 2010 and try to run my VBA Module containing MLOpen and MLPutMatrix functions, I get

Compile error can't find project or library

Answer 1

[MathWorks Support Team]

Please add a reference to Spreadsheet Link Ex. This can be done by clicking on Tools > References and adding the Spreadsheet Link Ex module. Refer to the following link:

https://www.mathworks.com/help/exlink/installation.html

If the above steps do not resolve the compile error, it is possible that other 3rd party references to modules are not installed correctly. The origin of the missing reference can be checked by trying to build a small example such as the one found here:

https://www.mathworks.com/help/exlink/create-diagonal-matrix-using-vba-macro.html