Description
What is VSTO?VSTO, short form of Visual Studio Tools for Office, is a technology that enables us to make more professional-looking and more performanced add-ins compared to Excel Add-ins by taking advantage of the. Net framework. VSTO add-ins are also known as COM Add-ins, if you are not familiar with javascript, they are the last point you should come to. However, if you want to see the differences between the state-of-the-art web add-ins and VSTO, there are lots of comparison pages on the net. Why you need it?You have become the hero of your department thanks to VBA. Now, it is time to set sail to deep waters. Here are some reasons why you should choose VSTO. If you don't want to deal with distributing your add-in to everyone one by one and explain them how to install itIf you want that any change you make in your add-in to be automatically updated for everyoneIf you want to take advantage of the power of the. Net framework (We will discover them over time)If you don't want your code to be seen by anyoneIf you want to create something for commercial purposesWhat do you need?Excel Object Model and preferably VBA knowledgeVisual Studio (We'll see how to install it)VBNet or C# (we'll learn how much is useful here, it's up to you to improve)IMPORTANT NOTE: Some parts(starting from 21) are not ready yet. They will be gradually available by the end of April 2023.
