Скачать или смотреть Wise Owl Answers - What's the difference between early binding and late binding in VBA?

Check out our other answers here    • Wise Owl Answers  

Get files here https://www.wiseowl.co.uk/vba-macros/...

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this link https://www.wiseowl.co.uk/donate?t=1​ to make a donation. Thanks for watching!

You may have written VBA code in Excel to reference another application by setting a reference to the application's object library. Did you know that you don't need to reference an application's object library to write code to control it? This video explains how to do this by switching from early binding to late binding in order to create a new Word document from Excel. You'll learn what changes you need to make to your code to allow this, how to use the CreateObject function and why late binding is so useful if you're sharing code with other people who may not be running the same version of an application as you.

Chapters
00:00 The Question
01:11 Referencing an Object Library
03:43 The Object Browser
05:05 Qualifying Variables with the Library Name
07:30 Building a Word Document
11:48 Saving a Document
13:09 Why Not Always use Early Binding
13:34 Fixing Missing References
15:37 Why We Need Late Binding
16:09 Defining Variables as Objects
18:17 Using the CreateObject Function
19:51 Replacing Constants with Numbers
22:27 Saving the Late Binding Code
22:49 Running the Late Binding Code

Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Power BI, DAX, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access and more