VB Function exported in XLL file

[Matthew Pfluger]

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

 

[RB Smissaert]

How about contact the makers of the code?
The website shows the contact details.

RBS

 

[Matthew Pfluger]

For the record, I have tried that. I was just interested in an alternate
route. The website is pretty old.

 

[RB Smissaert]

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]

Hmm. I missed that file the first time. Thank you for pointing out the
mistake.

Matthew Pfluger