Automatically install excel VBA add-in

Question

I have written excel VBA add-in file (.xlam). I also have a exported ribbon customization (.exportedUI). How can I create an installer so that my users can just run the installer to install the excel VBA add-in and the ribbon customization?

Answer 1

If you want a commercial tool, Advanced Installer has some built-in support for Office Add-in installers: http://www.advancedinstaller.com/user-guide/addins-tab.html

Another approach is using custom code to configure the add-in. Perhaps this will help: http://www.cpearson.com/excel/installinganxla.aspx