VBA to check and see if addin is loaded

jim101

Board Regular
Joined
Mar 22, 2005
Messages
108
Can you check with VBA to see if the Analysis Tool Pack and the Analysis Tool Pack VBA add-in libraries be loaded?
Thanks using excel 2003
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

jim may

Well-known Member
Joined
Jul 4, 2004
Messages
7,471
From Help

Code:
If AddIns("Analysis ToolPak").Installed = True Then
    MsgBox "Analysis ToolPak add-in is installed"
Else
    MsgBox "Analysis ToolPak add-in is not installed"
End If
 

Watch MrExcel Video

Forum statistics

Threads
1,109,161
Messages
5,527,156
Members
409,750
Latest member
BorisYeltsin

This Week's Hot Topics

Top