How do you take a vba addin and make an installer?
excel, vb6, vba
Solution
You can build an exe or msi installer with a tool such as Advanced Installer (the free edition). One thing you can do is copy files to a specific location and if you put it in the XLSTART folder then that add-in will automatically load for the user when starting Excel. There's a complimentary folder within the Excel program files directory, usually something like this
C:\Program Files (x86)\Microsoft Office\Office15\XLSTART
which if you drop xlam files into that folder they'll load by default too. The user specific option is
C:\Users[UserName]\AppData\Roaming\Microsoft\Excel\XLSTART
there are PROS/CONS to both models. One is will all users have access or just the user that installs. The benefit of the user specific option is it requires limited rights for installation (no admin privileges)
Problem
I have written a vba module that installs an addin button to excel. I would like to deploy it on many computers as easy as possible. Currently, these are my steps. - Save the excel as *.xlsm - Open the doc on the computer that I want to install - Save the document as an extension (*.xlam) which places it in the addin folder - Go to options>Add-Ins>Manage /Go> - Click the check box for my add in Is there a way to automate this process? Write something in vb?