|
By design, the macro object's Value property returns the raw (unexpanded) value of the macro. To retrieve the expanded value, use:
Application.ExpandMacros("%MACRO2%")
-or-
Application.ExpandMacros(macro.Value)
or if the macro value might also contain script expression(s), use ExpandMacrosAndScript instead of ExpandMacros.
|