View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default EARLY binding or LATE binding ?

Jason,

There are advantages and disadvantages to both. Intellectually, or perhaps
theoretically, I come down on the side of Early binding, practically I go
the other way.

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)

"jason" wrote in message
om...
I've been in de Bruin's website and he recommends (for binding Outlook
from inside Excel) using early binding first, because its easier to
write code with, and then to switch your code to late binding, as
it'll stand the test of time better

A friend at work understands late binding but swears by early binding

Any opinions - or can both be advantageous in different situations?

Jason