Testing for the presence of an AddIn?

[Guest]

On our trade floor some of our users have Bloomberg boxes, others use
Reuters. Each of these tools comes with an Excel AddIn to allow you to
retrieve real-time prices into a spreadsheet.

What I would like to do is write a macro to write in these formulas. In
theory this is easy, but there is one "trick", knowing whether it should
write a Bloomberg formula or Reuters one.

Is there a way to easily check for the presence of a known (by name) AddIn?
That would make this task fairly easy.

Maury

 

[Nigel]

The addins.installed property can be tested to determine if an addin is
installed, similarly saetting this property true/false will install/
uninstall it also.

eg......

If AddIns("analysis toolpak").Installed Then
MsgBox "Analysis Tool Pack Installed"
Else
MsgBox "Analysis Tool Pack Not Installed"
End If

 

[Jason Morin]

This code will add a new sheet, list the add-ins, and
indicated TRUE/FALSE for their installed status. Modified
from the VBA help file:

Sub DisplayAddIns()
Dim ad As AddIn
Dim AddInSh As Worksheet
Dim i As Long

Set AddInSh = Sheets.Add

i = 1
For Each ad In Application.AddIns
AddInSh.Cells(i, 1) = ad.Name
AddInSh.Cells(i, 2) = ad.Installed
i = i + 1
Next

End Sub

 

[Guest]

The addins.installed property can be tested to determine if an addin is
installed, similarly saetting this property true/false will install/
uninstall it also.

Awsome, thanks!

Maury