View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default Dumb early binding question

Early / late binding is more a question of how you define your variables.

Dim objOL as Object 'late
Dim objOL as Outlook.Application 'early

Set objOL = CreateObject("Outlook.Application") 'same for both

Benefits of early binding include getting Intellisense when writing your code: drawbacks include having to add a refence to the
library in your project.

see:
http://msdn.microsoft.com/archive/de...html/SF7A4.asp
http://www.dicks-clicks.com/excel/olBinding.htm


Tim

"Nicole Seibert" wrote in message
...
Okay... here goes:

Do you have to use CreateObject with set in early binding? For instance, I
have this lovely bit of code:

Set OutApp = Outlook.Application
Set xl = Excel.Application
Set data = xl.Workbooks("Time Exception Master Data")

Is this consider early binding? Should I instead say "Get" and then the
document path? I am confused.

Thanks,
Nicole