VB Function exported in XLL file
I use XlXtrFun.xll (see www.xlxtrfun.com) for interpolation and data
analysis. The web site says that most of its functions are capable of being called through VBA using a DECLARE statement. The VBDeclarations.XLS file included with the download contains examples of the most common functions and their declarations. However, the function I want to use through code, Intersect, has no example of how to declare the function in VB. Is there a way to view the functions of an XLL file? How can I determine how to call the INTERSECT function through VB? Thanks, Matthew Pfluger |
VB Function exported in XLL file
How about contact the makers of the code?
The website shows the contact details. RBS "Matthew Pfluger" wrote in message ... I use XlXtrFun.xll (see www.xlxtrfun.com) for interpolation and data analysis. The web site says that most of its functions are capable of being called through VBA using a DECLARE statement. The VBDeclarations.XLS file included with the download contains examples of the most common functions and their declarations. However, the function I want to use through code, Intersect, has no example of how to declare the function in VB. Is there a way to view the functions of an XLL file? How can I determine how to call the INTERSECT function through VB? Thanks, Matthew Pfluger |
VB Function exported in XLL file
For the record, I have tried that. I was just interested in an alternate
route. The website is pretty old. "RB Smissaert" wrote: How about contact the makers of the code? The website shows the contact details. RBS "Matthew Pfluger" wrote in message ... I use XlXtrFun.xll (see www.xlxtrfun.com) for interpolation and data analysis. The web site says that most of its functions are capable of being called through VBA using a DECLARE statement. The VBDeclarations.XLS file included with the download contains examples of the most common functions and their declarations. However, the function I want to use through code, Intersect, has no example of how to declare the function in VB. Is there a way to view the functions of an XLL file? How can I determine how to call the INTERSECT function through VB? Thanks, Matthew Pfluger |
VB Function exported in XLL file
Just downloaded it and this is in the documentation, in the file XtrFun
Declarations Release 200103.xls: Public Declare Function xtf_Intersect Lib "XtrFun.dll" ( _ dGivenX1s As Double, _ dGivenY1s As Double, _ ByVal lNumberOfX1s As Long, _ dGivenX2s As Double, _ dGivenY2s As Double, _ ByVal lNumberOfX2s As Long, _ dGuessAndReturnedX As Double, _ ByVal nInterpolateSpline1 As Integer, _ ByVal nInterpolateSpline2 As Integer, _ ByVal dAccuracy As Double, _ ByVal lMaxIterations As Long, _ ByVal dh As Double _ ) As Long RBS "Matthew Pfluger" wrote in message ... For the record, I have tried that. I was just interested in an alternate route. The website is pretty old. "RB Smissaert" wrote: How about contact the makers of the code? The website shows the contact details. RBS "Matthew Pfluger" wrote in message ... I use XlXtrFun.xll (see www.xlxtrfun.com) for interpolation and data analysis. The web site says that most of its functions are capable of being called through VBA using a DECLARE statement. The VBDeclarations.XLS file included with the download contains examples of the most common functions and their declarations. However, the function I want to use through code, Intersect, has no example of how to declare the function in VB. Is there a way to view the functions of an XLL file? How can I determine how to call the INTERSECT function through VB? Thanks, Matthew Pfluger |
VB Function exported in XLL file
Hmm. I missed that file the first time. Thank you for pointing out the
mistake. Matthew Pfluger "RB Smissaert" wrote: Just downloaded it and this is in the documentation, in the file XtrFun Declarations Release 200103.xls: Public Declare Function xtf_Intersect Lib "XtrFun.dll" ( _ dGivenX1s As Double, _ dGivenY1s As Double, _ ByVal lNumberOfX1s As Long, _ dGivenX2s As Double, _ dGivenY2s As Double, _ ByVal lNumberOfX2s As Long, _ dGuessAndReturnedX As Double, _ ByVal nInterpolateSpline1 As Integer, _ ByVal nInterpolateSpline2 As Integer, _ ByVal dAccuracy As Double, _ ByVal lMaxIterations As Long, _ ByVal dh As Double _ ) As Long RBS |
All times are GMT +1. The time now is 08:39 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com