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

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

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

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

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