OfficeSpy for Excel 2000

OfficeSpy creates an additional toolbar in Excel to provide quick access to the mostly used objects. If you are interested in other objects, they can easily be displayed by browsing their parent objects.

1. Application - the root of Excel Object Model

2. Window - current window in Excel

3. Workbook - current workbook

4. Sheet - current sheet

5. Chart - current chart in Excel (if one is selected)

6. Cell - currently selected cell

7. Selection - selected range in Excel

8. Style - style of the current selection

Excel Object Model interfaces

All Excel object model interfaces (in fact all IDispatch'able interfaces) can be browsed in a similar manner. You can examine the values of the properties live, if the objects exposes events interface, its log will be displayed, etc.

If an object you are interested in is not available on the OfficeSpy toolbar, you can always browse to it by starting from its parent object: 

Below is an example for an Application object.

	Properties tab shows a tree view of the particular object properties.  Properties that are in turn other objects can be browsed either directly in the tree view or in a similar window (if you want to call functions and/or trace that object events) by clicking "Browse" button or selecting "Browse in New Window" from a popup menu.  Clicking "Help" button shows a help topic for the property (if VBA help file is installed).
	Functions tab displays a list of functions and array properties available for the object along with required parameters. Clicking "Call" invokes dialog box to set function parameters (if there are any). If function result is another object, a new window is open to browse it.
	Events tab shows a list of all available events for the object along with parameters to be passed to the event handlers. If no events are available, this tab is not present. Example above shows events for an Application along with an event log. If do not want to trace a particular event, uncheck it in the list of events.