I think you need to turn the problem inside out. Store the array as a VBP macro and use a bit of script to extract the elements one at a time, perhaps to another VBP macro.
In similar situations I use strings of comma delimited elements as an "array" and have a script function that pops the first element off the list.
|