Use Object Browser to Discover Undocumented Features

Use Object Browser to Discover Undocumented Features

If you right-click on the right-most pane of the Object Browser, you can issue the Show Hidden Members command. From this point on, the Object Browser shows all hidden properties and methods in any library, and you can use it to explore all object libraries in more detail. For instance, the VBA library exposes a hidden class, appropriately named “_HiddenModule,” which includes many well-known VBA functions plus three undocumented ones: ObjPtr, StrPtr, and VarPtr. ObjPtr returns the address of the private area of an object instance, StrPtr returns the address of the first character in a string, and VarPtr returns the address of a variable or a string descriptor, if you pass it a string variable.

Share the Post:
data observability

Data Observability Explained

Data is the lifeblood of any successful business, as it is the driving force behind critical decision-making, insight generation, and strategic development. However, due to its intricate nature, ensuring the

Heading photo, Metadata.

What is Metadata?

What is metadata? Well, It’s an odd concept to wrap your head around. Metadata is essentially the secondary layer of data that tracks details about the “regular” data. The regular