MacroExpansionProvider API
The MacroExpansionProvider has an API that you can use to implement your macros.
The API provides services and properties for getting information about the current solution, metadata about objects in the solution, the arguments passed to the current execution context (typically originating from SetParamValue(…) in Workbooks), and so on.