hi all,
I am new to macro vba. Help me to solve below query
I am having a xml file. Get a xml file by clicking on a button. i want the specific values from that 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 90percent.
I need to get the script names and the corresponding transaction names with 90percent values.
I have attached my sample xml file.
I have to get the output in excel in the format below.
----------- SCRIPT NAME - Script1_29042014.bdf/VUser-Profile1 ----------------
Transaction Name 90Percentile
17_Recentwork 0.267590953
T01_Launch 0.461530000
T02_Click_Login 0.906243333
----------- SCRIPT NAME - Help_29042014.bdf/VUser-Profile1 ----------------
Transaction Name 90Percentile
Help_T01_Launch 0.452333333
Help_T02_Login 0.811000000
Bookmarks