The code goes generally like this... check if the addin is installed. If not
add the addin and then install it...

If Not AddIns("Hyperion Essbase OLAP Server DLL").Installed Then
On Error Resume Next
Application.AddIns.Add "C:\Hyperion\Essbase\Bin\essxleqd.xla"
Application.AddIns.Add "C:\Hyperion\Essbase\Bin\essexcln.xll"
AddIns("Hyperion Essbase OLAP Server DLL").Installed = True
On Error GoTo ErrorHandler
End If

--
HTH...

Jim Thomlinson


"tjh" wrote:

How can I install an add-in using vba code.

Thank You,