Build powerful add-ins in Excel
What is VSTO?
What you’ll learn
- Creating VSTO(COM) Add-ins with c#.
- Creating custom ribbons.
- Creating custom taskpanes.
- Going beyond the VSTO by learning to use 3rd party libraries..
Course Content
- Introduction –> 3 lectures • 12min.
- .Net Framework –> 6 lectures • 40min.
- First Add-in Project –> 4 lectures • 53min.
- Creating Ribbons and Taskpanes –> 6 lectures • 50min.
- Third Party Libraries –> 4 lectures • 10min.
- Deployment and Publishing –> 2 lectures • 1min.
- Working with other programmes –> 5 lectures • 1min.
- Examples –> 1 lecture • 1min.
Requirements
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 it
- If you want that any change you make in your add-in to be automatically updated for everyone
- If 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 anyone
- If you want to create something for commercial purposes
What do you need?
- Excel Object Model and preferably VBA knowledge
- Visual 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.