NathaneilCapital since you don't have any code I will just explain the procedure for you.
Adding a new add-in and installing it (make it appear on the ribbon) is very easy.
Adding an Add-In:
Copy your xlam file to the library folder using FileCopy command. You can get the address where you should copy the file TO easily like this:
sAddInPathTo = Application.UserLibraryPath
sToFullName = sAddInPathTo & "\" & "MyAddInName.xlam"
FileCopy sFromFullName, sToFullName
At this point if you go to Developer/Add-Ins you would see the name of the addIn but the checkbox next to it is not checked meaning it is not enabled/installed. To do that you can use:
AddIns("MyAddInName").Installed=True
After this line, your add-in should appear on the Excel ribbon as a new Tab.
To uninstall the add-in you can simply so this:
AddIns("MyAddInName").Installed=False
If you would do this manually, you should open up the AddInInstallerManager (Developer/Add-Ins) and uncheck your add-in.
However, removing it from the Add-Ins list in the AddInInstallerManager is more complicated. First, you should delete the xlam file from the library address which is simply done by using:
Kill sToFullName
Make sure you uninstall first, otherwise windows will not be able to delete the file.
Second, which is the most difficult part is to clean the registry. In fact after the above mentioned line, you would see the add-in name in the AddInInstallerManager, but when you browse you would not see the xlam file there, which is kind of inconsistensy. Because AddInInstallerManager lists those add-ins from an ini file. Practically if you get to this point, it is still fine and in case Excel finds out about it, it will refresh the ini file and you should be good, but to do this manually, you can open the AddInInstallerManager and when you click on the name of the add-in, it will throw and error for you and then it will remove it from its list. You can do this either but using send keys to simulate it or simply modify the registry. See this for more information:
http://www.jkp-ads.com/articles/addinsandsetupfactory.asp
AddIns("Title").Installed=Falsemethod, but I tried, it doesn't disable it.(At least the addin menu item is still there.