Building an Add-in for Excel, Creating the add-in
We've done the hard part of creating our tool, we're done programming. What is left to do is converting your workbook to an add-in and testing the tool.
Creating an add-in
Creating an add-in is as simple as clicking File, Save As:
In the save-as window, click the "Save As Type" dropdown and select "Excel Add-in (*.xlam)":
When you select Excel Add-in, Excel is kind enough to confuse you by changing the folder to the standard add-ins folder on your system. Since I NEVER want to save my add-ins there, this really annoyed me. Until someone pointed me at the fact that you can simply click the Back button to take you back to the original folder you last opened a file from (or saved a file to):
That's it, press Save and your add-in is ready for publication!
Perhaps these articles are also of interest:
- A series about distributing macro's I've written quite some time ago.
- An article about Updating an add-in through the internet
- An article about installing add-ins using Setup Factory
- An article about fixing links to UDFs in your add-in
- An article about keeping your userform on top of Excel 2013's windows