How-To: Office Spy
Office Spy adds its own ribbon page to Office applications so you can inspect the current Office object context.
Registration
Entering a license key
If you received an Office Spy Manager license key, open any Office application, go to the Office Spy ribbon, and click About.
Enter the license key in the About Office Spy dialog box.
Object browser
Browsing collection elements
Some objects represent collections, but initially show only an item count. For example, when you click the Database button in Access, you can select and expand the TableDefs property, but only the Count subproperty is visible.
Select the collection property and click Browse. Office Spy opens a new window for that object.
Open the IEnumVariant tab, which is available on objects that support for each iterators, and double-click the element you want to inspect.