Hi p45cal,
I did a test run and I got a "Run-time error76": Path not found error.
I changed code below:
xx = FSO.OpenTextFile(myFullPathAndNameSource).ReadAll 'your source file
to:
xx = FSO.OpenTextFile(C:\XML_Source_Files\).ReadAll 'your source file
and it did not fix the error.
I have attached Zip file containing my test XSLM file containing your VBA. I also included 4 XML test data files to apply the change to. My hope is these files better communicate the task I need the VBA to perform. I would be very grateful if you or anyone in this forum can help me developing this VBA. Thanks for the help and I look forward to seeing this VBA do its magic.