As you surely know, VBA allows to write very complex applications simplifying and optimizing business processes in a company. However VBA is gradually beginning to reach its limits and will certainly be removed in one of the future versions of MS Office. Major shortcomings of VBA applications are the low protection of the VBA Code or missing code management tools. With VSTO – Visual Studio Tools for Office – Microsoft provides specific templates and interfaces in Visual Studio to develop office applications based on .NET. This also means that the full power of .NET applications is made available to office Add-Ins. And, very important, the code is managed, each line of code is verified for its rights before excecution.
On one hand, you can create document based solutions with VSTO and, on the other hand, solutions on the application level. You need Visual Studio for using VSTO. Currently VSTO is available in Version 3.0.
For some time, I’m playing a little with this new possibilities. My first goal is to be able to migrate my VBA applications in the near future as effectively as possible. Certainly I will not avoid to rewrite some parts of my code and this would not be done in a few days, as some of my applications are containing more than 50.000 lines of code. So, I was searching the internet for tools for simplifying the migration process. I found the company „Add-In Express“ offering tools for what I was searching.