Vignesh,

Advantages of Early Binding:

1. Your code will run considerably faster, because it can all be compiled up front.

2. Debugging is far easier – select Debug + Compile, and the compiler will be able to spot syntax errors.

3. You have full access in your project to intellisense (you can type a keyword and a dot to get a popup list of properties and methods supported by that keyword, select one to insert it).

4.You have full access to the application's object model via the Object Browser and VBA Help.

5. You have access to the application's built-in constants.

All these advantages make programming using early binding immeasurably easier than using late binding.


Advantages of Late Binding:

The main advantage is that code which uses late binding is more certain to be version-independent

Dis-Advantages of Late Binding:

The more references your project contains and the larger the file size.

With late binding, the code relating to an application you declared as an object has to, in effect, be compiled as it runs ultimately leading to longer time for compilation.

__________________
H2O

Without us, no one can survive..