<<It answers a question on CreateObject against New, but as these are
intrinsically tied to late vs.
early binding

Hi Bob,

The only thing that determines late binding vs. early binding is the
object variable declaration.

Dim X As SpecificObject

is always early bound and

Dim X As Object/Variant

is always late bound.

Set X = CreateObject("Lib.SpecificObject") and Set X = New
SpecificObject both return strongly typed references to the object in
question. The only difference is that New uses the object's type library
directly while CreateObject looks up the details in the registry, making New
a bit more efficient. The return result of either CreateObject or New can be
assigned to either an early bound or late bound variable.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *


"Bob Phillips" wrote in message
...
Grey,

Here is a previous post of mine that talks abort developing using early
binding (for development ease) and changing to late binding (for release)
use mail as its example. And another post on the advantages/disadvantages or
early/late binding.

Take a look at this recent discussion on the topic. It answers a question on
CreateObject against New, but as these are intrinsically tied to late vs.
early binding, that is what is really discussed.

http://tinyurl.com/2ay78

And here is a previous post of mine on how to go about the approach that Ron
discusses, so you will get an idea of the overhead

http://tinyurl.com/2qern



--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Grey" wrote in message
...
I have to send mail in excel in different windows versions. how to use the
late binding to initiate the objects??

Million thanks