Get specifiv Values from xml file and paste it in excel using VBA

Hi all,

I am having a xml file. i want the specific values from the xml and paste it in the excel file using vba.

In that xml file, there will be so many scripts and the corresponding transaction names with the value of 90 percent.
I need to get the script names and the corresponding transaction names with 90 percent values.
I have attached my sample xml file.
The output in excel should be:

----------- SCRIPT NAME - Script1_29042014.bdf----------------

Transaction Name 90Percentile

17_Recentwork 0.267590953
T01_Launch 0.461530000
T02_Click_Login 0.906243333

----------- SCRIPT NAME - Help_29042014.bdf----------------
Transaction Name 90Percentile

Help_T01_Launch 0.452333333
Help_T02_Login 0.811000000

As per your request i have attached a excel file.

attached a excel file.

in excel format

Hi all,
i am new to macro. Any one can help me to do this?