The information in this article applies to:
SUMMARY
This article explains three methods you can use to navigate and access
Excel Application objects:
MORE INFORMATIONEach object in Microsoft Excel version 5.0 exists somewhere in the application's hierarchy of objects. You choose among these objects by navigating down that application's hierarchy. At the top of this hierarchy is the Application object. Whatever events or actions you assign to the Application object affect the entire application. For example:
Replace [Object] with any variable that points to any valid Excel
Application Object, which can be created from the following example:
The Application object contains other large objects. For example, you can
use the following code to refer to the collection of Workbooks currently
loaded in Excel:
If you want to retrieve a single workbook from the collection, use the Item
method. For example, to refer to the first workbook:
To close the first workbook:
Accessing Objects Using Longhand Reference or Default PropertiesEach workbook contains a collection of worksheets, each worksheet contains a collection of cells, and so on. (See the Excel documentation and Help menu for specific details about Excel's object hierarchy.) In code, referring to a specific cell could look like this:
This reference can be lengthy and complex; however shortcuts are available.
Understanding the navigation operator (.) is fundamental to successful
object programming.
Short Cuts: All objects have a default property and method. For collections the default method is the Item method. For most objects the Name property is the default property. This convention was implemented to simplify programming. For example the previous sample can be simplified to:
Accessing Objects by Aliasing ObjectsYou can use aliasing to simplify object programming. If you were to write a lot of code that was manipulating Sheet1, for example, the syntax could become lengthy. To prevent this, create an object that points to the lowest common object. This is known as aliasing. Use the Set statement to create an alias.
Accessing Objects by Using Parent and Application MethodsThe Parent and Application methods allow you to navigate back up the object hierarchy. The Application method navigates back to the application object, and the Parent method navigates up one level of the object hierarchy. All the examples in this article started with [Object]. As long as [Object] is a valid Excel object, all of those statements are also valid, regardless of the context of [Object].This is very helpful when programming the Excel object from Visual Basic version 3.0. Excel exposes only the three objects that can be used as entry points to Excel. These are:
There is no exposed Workbook object, so there's no way to access the Workbook object directly. However, this is not a problem because the Parent method of a Worksheet or Chart object returns the Workbook object. The following example code illustrates this point. NOTE: oleExcel is an OLE control that contains an Excel.Sheet object.
REFERENCES- Office Development Kit, Programming Integrated Solutions Additional query words: officeinterop w_VBApp W_Excel WM_OLE OA OLE Automation
Keywords : kbprg IAPOLE vbwin |
Last Reviewed: June 30, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |