This example adds the add-in named "Myaddin.ppa" to the list in the Add-Ins dialog box and loads the add-in automatically.
Set myAddIn = Application.AddIns.Add(FileName:="c:\myaddin.ppa")
myAddIn.Loaded = True
MsgBox myAddIn.Name & " has been added to the list"