Excel Vsto Add-Ins

Build powerful add-ins in Excel

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.

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.