View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
RB Smissaert RB Smissaert is offline
external usenet poster
 
Posts: 2,452
Default 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