ActiveX/COM Inspector - 1.0

A name is associated with each object based on the value of its properties. Here we can see that each HTMLImgClass object is named after the image file (redcurtain728x90.jpg for example).

The screen shot to the right shows the list of events as they occur. The shot below shows the detail of a selected event. Note that the event parameters appear in the detail as links if they are an object. Clicking on them presents the object in the object tree.

The number under "Inc" is the event incarnation. This is used to determine which the causal relationship of events. The first event with the same incarnation number caused the other events with that number. You can see this in the event with incarnation number 27.

When you open (by expanding) a registered type library, it is automatically moved to the Favorite part of the tree for easy access in the future.

When a type library is opened, it is automatically converted to a .NET assembly (because the Inspector uses the .NET interoperability for access to ActiveX/COM). This assembly is viewed in the Assemblies/Types panel (not shown, it is selectable as an option).

Here we see two controls from the Microsoft Forms type library on the design surface. Note that they can be resized or moved using the forms designer.

You want to find out how to write VB/VBA code to copy the range of cells A1-C1 to A3 in a spreadsheet. You don't know anything about the Excel Automation interface. more