July 5, 2013 in VBA
Pointers and memory for Variant variables In the Component Object Model (COM) Automation framework, the VARIANT structure provides a wrapper for passing around any type of data, and a suite of manipulation functions facilitate using the VARIANT as a platform-level dynamically-typed variable. I say platform-level because the structures, enumerations, and functions that implement VARIANTs exist at the Windows API level. Any language — including those that are not dynamically typed — can use the API to accomplish something like dynamic types. VBA does provide dynamically typed variables, and calls them Variants, just like the supporting structures in the COM API.