Automatically install add-in into Excel

[MDA]

Hi all,

I have an Excel add-in that is installed in a special folder using MS installer. Is there a way that I can programmatically install the add-in into Excel and select it as an add in, without any user interaction? Keep in mind that I have to install the add-in xla file in a special directory.

Thanks for any ideas!

Regards,

MDA

 

[MDA]

In case anyone needs the code for this task, I figured it out....

------I used a VB application to do this -----

Private Sub Form_Load()
Dim oXL As Object, oAddin As Object
Set oXL = CreateObject("Excel.Application&quot
oXL.Workbooks.Add
Set oAddin = oXL.AddIns.Add("C:\Program Files\Myapp\MyAddin.xla", True)
oAddin.Installed = True
oXL.Quit
Set oXL = Nothing

End Sub
-----------------------

MDA