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

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

--
Cheers
Nigel



"Maury Markowitz" wrote in
message ...
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

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

---
HTH
Jason
Atlanta, GA, USA

-----Original Message-----
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" wrote:

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