XNPV and XIRR

[Bob]

If I use the Analysis Toolpack Add-in functions XNPV and XIRR would they be accessible to anyone
that uses my workbook?..or do they need to have them installed, too?

Thanks in advance,

Bob

 

[Dave R.]

It needs to be 'installed' on anyones computer who uses it, otherwise the
returned value will be #NAME?

 

[Frank Kabel]

Hi
they also need to install the Analysis Toolpak Add-In

 

[Norman Harker]

Hi Bob!

You have the bad news.

The good news is that you can use a Workbook_Open event handler to
check for Analysis ToolPak being installed. I call the following
subroutine from my Workbook_Open subroutine:

Sub AnalysisToolPak_Exists()
Dim Item As AddIn
Dim AnalysisToolpak As Boolean
AnalysisToolpak = False
For Each Item In AddIns
If Item.Name = "ATPVBAEN.XLA" Then AnalysisToolpak = True
Next Item
If AnalysisToolpak = False Then
Analysis_ToolPak_Not_Present.Show
End If
AddIns("Analysis Toolpak").Installed = True
AddIns("Analysis ToolPak - VBA").Installed = True
End Sub

It's pretty old and crude but has served me well. Any improvements
welcomed.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.