Microsoft Office Tutorials and References
In Depth Information
automatically appear as you type your code. Syntax checking and type checking is also
performed 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.
Search JabSto ::

Custom Search