Bessel functions in VBA for Excel

[Marshall Price]

You can calculate Bessel functions of the first kind of order n from
the Gamma function, if it's available.

Alain Besson wrote:
: If the add-in Analysis Toolpak is loaded, we can access the Bessel function
: BESSELY(x,n). However, this function is not available in Visual Basic
: functions (Application.Worksheetfunction.BESSELY does not work). Does
: somebody have an idea on how to access such a function in VBA?

: Thanks

: alain....@rdor.nestle.com

--
Marshall Price of Miami, Florida
d021...@dc.seflin.org

[Harlan Grove]

In article <8mt87i$g...@nntp.seflin.org>,

d021...@dc.seflin.org (Marshall Price) wrote:
>You can calculate Bessel functions of the first kind of order n from
>the Gamma function, if it's available.
>
>Alain Besson wrote:
>:If the add-in Analysis Toolpak is loaded, we can access the Bessel
>:function BESSELY(x,n). However, this function is not available in
>:Visual Basic functions (Application.Worksheetfunction.BESSELY does
>:not work). Does somebody have an idea on how to access such a
>: function in VBA?

In English language versions of Excel one must add a reference to
ATPVBAEN.XLA to the workbook from which you want to call Engineering
functions included in the Analysis Toolpak. The file on your system may
have a different name if you're using a non-English version of Excel.
However, the beginning of the filename is likely to remain ATPVBA.

These are the instructions for the Englich version. In the VBA editor
(VBE), select the top level entry for the workbook in the Project
Explorer, choose Tools > References from the VBE menu, check the box to
the left of atpvbaen.xls (on my system it ends with '.xls' even though
it's a .XLA file), and click OK. You should now have access to BesselY
() as BesselY(). It's not a method of Application.WorksheetFunctions.

Sent via Deja.com http://www.deja.com/
Before you buy.