Nested macros
 

I am trying to use a crude version of macro arrays and running into issues. I would like it be able to have 3 (or more) macros with the names

SUMMARY0
SUMMARY1
SUMMARY2

and I would like to access them based on an index named %INDEX%. So that I can dump the contents to a file. So I would use a WriteTextToFile command to write the correct value to a file something like

%DATA%, %MY_FILE%, %INDEX%, %%SUMMARY%INDEX%%

Is this possible??

Ken

[vbld_AllMacros().Item("SUMMARY" & vbld_AllMacros().Item("INDEX").Value).Value]

or

[Application.ExpandMacros("%%SUMMARY" & Application.ExpandMacros("%%INDEX%%") & "%%")]