Hi,
I am newbie and not a programmer.
I have an XML files in folder and sub folders and I’m trying to parse particular information from this file. I can do this manually but can’t figure out a macro that will allow me to do this. I attached the lines tags that I will have to pull out of many files from folders and sub folders. Search criteria is “Amount, Serial No,TruncatingRTNo”.Get the search from userform, Any Ideas?
The search folders tree:
Main folder
Folder1 —> *.xml data file
Folder2—-> *.xml data file
Folder3—-> *.xml data file
XML Data Sample:
SOME MORE STUFF HERE…………