Blog posts

A Call Hierarchy shows calls of a given procedure by other procedures, and calls from that same given procedure to other procedures.

Calling the members of a dynamic-link library (DLL, in a .dll file), from VBA code, without having to first (separately) register that DLL.

Have you ever been in the situation where you have two versions of a Module and need to identify the differences?

Have you ever wanted to know what is in a Type Library without having to add a Project Reference to it from your VBA Project?

Ever needed to convert an Enum member's name to its value when changing from early to late binding? Read this ...

If you develop your VBA code using early binding but switch to late binding when deploying, then 'special binding' may be useful to you.

Show All Members is a larger, searchable, filterable equivalent that also shows, where available, the 'doc string' for members.

A better way to add, update and explore the available "Project References" (Type Libraries and other VBA Projects)

Update October 2024: This post uses Visual Studio and/or RegAsm to 'statically' register your C# library before it is loaded and used by...