I could've swore I've seen this posted before, but I can't find it. I know I can enumerate a dictionary to pull it into an array, but I was pretty sure you could also use the Array function to pull it into an array.
I can get it to work with a join on the dictionary then a split on the join, but only if the array isn't already defined.
Code:
Dim aArray()
oDictionary = CreateObject("Scripting.Dictionary")
oDictionary.Add 1,"A"
oDictionary.Add 2,"B"
oDictionary.Add 3,"C"
aArray = Array(oDictionary.Items)
I can get it to work with a join on the dictionary then a split on the join, but only if the array isn't already defined.