XNPV and XIRR

  • Thread starter Thread starter Bob
  • Start date Start date
B

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
 
It needs to be 'installed' on anyones computer who uses it, otherwise the
returned value will be #NAME?
 
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.
 
Back
Top