Not sure on the exact error you are getting here but you need to make sure you're accessing the correct part of the xml to get the articulation name in the sound slot, not the name in the articulations box.
If you have a look at these two threads this explains how I have used vba to pull the map name, the articulation and the colour into excel. From excel I can then easily create the variables text that I copy into my custom module.
thank you very much!
i have to check that out asap.
i tried it with a json because of the arrays. these could be accessed some how through the custom module and then i think it wouldn't matter from where you pull it. i'm talking like i'm a programmer but i have nearly no plan what i'm doing programming wise. copy paste and try my best to think logical is the way i went.
i could remove the BOM. no more error. now i have to figure out how to access the data from the custom module. there are like billions of arrays
and i have no clue how to access them and pull the data i need. i'm gonna try anyway but if you could give me a hint that would be great.