NumXL with VBA and Excel Macro

Question:

Can I use the NumXL function with VBA or in an Excel macro?

Answer:

NumXL is an Excel add-in and is compiled for high speed. For this reason, it cannot be accessed directly from Visual Basic or from macros. Nevertheless, you can use NumXL indirectly from Visual Basic for Applications (VBA) within Excel only by using the "Run" command. For example:

Public Function GEDi_XKURT(a)
GED_XKURT = Run("GED_XKURT", a)
End Function

Now GED_XKURT can be used as a spreadsheet function.

For developing Visual Basic applications, we recommend using the NumXL SDK - C/C++, Java, and VB callable object libraries.

Comments

Please sign in to leave a comment.

Was this article helpful?
0 out of 0 found this helpful