Early and Late Binding (Object Variables) || Excel VBA Master Class || 3.3b
The concept of binding objects to variables is important to know especially, when accessing external applications such as PowerPoint and Outlook.
Early Binding is when we declare objects using a specific Object type.
Late Binding is when we declare objects using a generic Object type.
In this lesson, we will learn:
How to differentiate Early Binding from Late Binding
How to access external applications
The difference between Run-time and Compile-time
How to convert code from Early Binding to Late Binding
#vba #excel
Follow the rest of the series, in the below playlist:
• VBA MasterClass
Code snippets can be found here:
https://skillsandautomation.com/maste...
00:00 Intro
00:25 Syntax
01:25 Accessing External Applications
07:05 Compile-time vs Run-time
10:07 Why use late binding
11:30 Converting code to late binding
