To call an add-in function via a COM wrapper, you should:
For example, to invoke the NORMSDIST2 function from the Tutorial1 XLL:
Dim addin As New Tutorial1Lib.Tutorial1 MsgBox addin.NORMSDIST2(0.5) Set addin = Nothing
See also the remarks on Performance considerations.
XLL+ COM wrapper generator | Using the wrapper generator | Generated code