View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
trooper665 trooper665 is offline
external usenet poster
 
Posts: 8
Default Late Binding or Late Anything

One other benefit of late-binding that is not mentioned is that you do not
need to recompile your code if the object that you are referencing has
changed. If you use early binding you do need to recompile your code every
time your referenced object is updated.

Jeff

"Leith Ross" wrote:


Hi Piranha,

It's a term relating to assigning object variables. Here is some info
from the Microsoft Developers Network Site (MSDN) that should help
you.

The Visual Basic compiler performs a process called binding when an
object is assigned to an object variable. An object is early bound when
it is assigned to a variable declared to be of a specific object type.
Early bound objects allow the compiler to allocate memory and perform
other optimizations before an application executes.

By contrast, an object is late bound when it is assigned to a variable
declared to be of type Object. Objects of this type can hold references
to any object, but lack many of the advantages of early-bound objects.

You should use early-bound objects whenever possible, because they
allow the compiler to make important optimizations that yield more
efficient applications. Early-bound objects are significantly faster
than late-bound objects and make your code easier to read and maintain
by stating exactly what kind of objects are being used. Another
advantage to early binding is that it enables useful features such as
automatic code completion and Dynamic Help because the Visual Studio
.NET integrated development environment (IDE) can determine exactly
what type of object you are working with as you edit the code. Early
binding reduces the number and severity of run-time errors because it
allows the compiler to report errors when a program is compiled.

Note Late binding can only be used to access type members that are
declared as Public. Accessing members declared as Friend or Protected
Friend results in a runtime error.

Hope this answers your questions,


--
Leith Ross


------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=476077