Analysis Toolpak - VBA add-in
 

How do I use the analysis toolpak for VBA? I loaded the add-in, but I can't
seem to find any of the functions, and it asks for a password to open the
atpvbaen project.

Analysis Toolpak - VBA add-in
 

you don't need to open it.

just use the functions, for example,

=eomonth(a1,1)

if a1 has a date in it

--


Gary

"VBA_EE_Engr" wrote in message
...
How do I use the analysis toolpak for VBA? I loaded the add-in, but I
can't
seem to find any of the functions, and it asks for a password to open the
atpvbaen project.

Analysis Toolpak - VBA add-in
 

If speed is important, eg calling the ATP multiple times, set a reference to
Atpvbaen.xls in Tools References. Otherwise use Application.Run

Sub test()
Dim start_date As Date, eom As Date
Dim months
start_date = Date
months = 12
' with a ref to the addin works fast
eom = EoMonth(start_date, months) ' with the ref
MsgBox eom

months = 1

' this works without the ref but much slower
eom = Application.Run("EoMonth", start_date, months)
MsgBox eom
End Sub

Regards,
Peter T


"VBA_EE_Engr" wrote in message
...
How do I use the analysis toolpak for VBA? I loaded the add-in, but I
can't
seem to find any of the functions, and it asks for a password to open the
atpvbaen project.