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?
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?
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.
Last edited by AB33; 02-01-2015 at 12:44 PM.
I had the same question. See: http://www.excelforum.com/excel-prog...e-binding.html
*******************************************************
HELP WANTED! (Links to Forum threads)
Trying to create reusable code for Custom Events at Workbook (not Application) level
*******************************************************
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks