Early vs Latebinding is one better than the other?

[welchs101]

Hi,

A question came up in one of my other threads concerning "early vs latebinding". I use dictionaries a lot now in my code and i have been using "latebinding".

What are the advantages / disadvantages of using one vs the other?

[AB33]

Here are few links

http://peltiertech.com/Excel/EarlyLateBinding.html

https://msdn.microsoft.com/en-us/library/0tcf61s1.aspx

http://programmers.stackexchange.com...d-late-binding

In a nutshell, Generally speaking Early binding is faster than late binding, you have access to auto complete so it is easy to code as you get help from VBA, ie you do not need remember all the methods and properties you are accessing.
But you need to reference the object by going to tools which means a person receiving your code should reference the object, otherwise, they will get an error "A user defined object is not defined". Late binding can work with any version with out referencing the object.

[mc84excel]

I had the same question. See: http://www.excelforum.com/excel-prog...e-binding.html

[AB33]

mc84excel,
Thank you for posting the link! A year is a long time in VBA.
I now see the benefit of early binding of using Intellisense. I am getting old, so can not remember some of properties and methods of an object. ADO is the case in point.