reference exceldna in vba

Apr 5, 2009 at 6:11 PM

I created some functions in exceldna as script files in vb.  I load exceldna.xll everytime i open excel.  these function are available under "exceldna".  When I use these functions are part of a function I am creating in vba, the debugger says "compile error.  Sub or Function not defined".  How can I use the exceldna functions in vba?

thanks,

dave

Coordinator
Apr 6, 2009 at 10:27 AM
Edited Apr 6, 2009 at 10:28 AM
Hi Dave,

You should try:
result = Application.Run("MyFunction", param1, param2)

Regards,
Govert