Creating VSTO(COM) Add-ins with c#
Creating custom ribbons
Creating custom taskpanes
Going beyond the VSTO by learning to use 3rd party libraries.
Requirements
Preferably experience with VBA, good command of Excel Object Model
Description
What is VSTO?VSTO, with its clear name Visual Studio Tools for Office, is a technology that enables us to make more professional looking and more performance add-ins compared to Excel Add-ins by taking advantage of the .Net framework. You must be knowing three types of add -ins. 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?Now, you have become the hero of your department with 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 how to install it.If you want an update you make 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 write 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.
Overview
Section 1: Introduction
Lecture 1 Introduction
Lecture 2 2 Ws 1 H
Lecture 3 3 types of Add-ins
Section 2: .Net Framework
Lecture 4 .Net Framework in short
Lecture 5 Visual Studio
Lecture 6 First codes on VS console
Lecture 7 Visual Basic-Part1
Lecture 8 Visual Basic-Part2
Lecture 9 C#
Section 3: First Add-in Project
Lecture 10 Excel Object Model
Lecture 11 Range
Lecture 12 Document Level Add-ins
Lecture 13 Break for experiencing in .Net environment
Section 4: Creating Ribbons and Taskpanes
Lecture 14 Ribbons-Part1
Lecture 15 Ribbons-Part2
Lecture 16 Ribbons-Part3
Lecture 17 Adding resources and common properties and tips
Lecture 18 DialogLaunchers and Creating Setting Files
Lecture 19 Taskpanes
Section 5: Third Party Libraries
Lecture 20 Nugget Manager
Lecture 21 ClosedXML-Part1
Lecture 22 ClosedXML-Part2
Lecture 23 Writing UDFs with Automation Add-ins
Lecture 24 Writing XLL-based UDFs with Excel DNA
Section 6: Working with other programmes
Lecture 25 Working with MS Office - Introduction
Lecture 26 Working with MS Outlook
Lecture 27 Working with MS Access
Lecture 28 Using our VSTO code in VBA
Lecture 29 Working with other programming language files
Section 7: Deployment and Publishing
Lecture 30 ClickOnce Deployment
Lecture 31 Creating a Windows Installer
Section 8: Examples
Lecture 32 Fuzzy-match application (Includes python)
Those who want to level up their ability of excel programming.

Homepage

https://www.udemy.com/course/excel-vsto-add-ins/