Yes, but this requires me to have the knowledge of what that particular
addin is called in different languages. I would like to have a language
independent method.

- Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=269165

Try this:

Sub ToolPakActivate()
Dim ai As Object
For Each ai In Application.AddIns
If UCase$(ai.Name) = "ANALYS32.XLL" Then
If Not ai.Installed Then ai.Installed = True
Exit For
End If
Next
If ai Is Nothing Then
MsgBox "Run setup to install the Analysis Toolpak"
End If
End Sub

Note the installed property indicated that the addin is LOADED.


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


mangesh_yadav wrote:


Yes, but this requires me to have the knowledge of what that particular
addin is called in different languages. I would like to have a language
independent method.

- Mangesh