VB Function exported in XLL file

  • Thread starter Matthew Pfluger
  • Start date
M

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
 
R

RB Smissaert

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

RBS
 
M

Matthew Pfluger

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

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
 
M

Matthew Pfluger

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

Matthew Pfluger
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top