• Setting up a Project in Visual Studio 2013 and 2015 (XLW Part 2)

    Update:Added instructions for VS2015 (2016-07-16) The last post was the introduction to the series of XLW related posts. Today I will describe how to set up a project with XLW. XLW comes with an installer that installs the project templates for your development environment. It is a quick way to start, but you don’t have much control over the process and the project template might not match your expectation on how project should be arranged.
  • Building Excel Add-ins (XLW Part 1)

    This is a first post from a series devoted to building xll add-ins for Excel. Add-ins are used to extend Excel functionality. It is possible to extend Excel using VBA in the same spreadsheet. However this way VBA code is tightly coupled with the spreadsheet, which makes it difficult to keep track of code versions or update code for all copies of a spreadsheet. Users often make copies of spreadsheets because they want to modify something but want to keep original around.