Page 492 - Microsoft Office Excel 2003 Programming Inside Out
P. 492
Microsoft Office Excel 2003 Programming Inside Out
automatically appear as you type your code. Syntax checking and type checking is also per-
formed as you code, so you are less likely to get errors when the code executes than with
late binding.
You must use the CreateObject or the GetObject function to create an object variable reference
to the target application when using late binding. You can use the same functions when early
binding, but it’s more efficient to use the New keyword. However, if you want to test for an open
instance of another application at run time, GetObject can be used with early binding as well.
The techniques presented in this chapter allow you to create powerful programs that tap into
the unique abilities of different products. The user remains in a familiar environment such as
Excel, while the code ranges across any product that has a type library and exposes its objects
to VBA.
Chapter 21
466
Part 6: Excel and the Outside World: Collaborating Made Easy
