Need macro code to get the result on comparing 2 xml files

[knaa]

I am very new to Excel macro and just started in learning the techniques. For one of my project, i need a tool to get me the below expected results.1). XML file1 will have the Question-ids like below001Your Full name2). XML file2 will have the answer responses for the question-ids present in file1001testHere is my expectation:Output would be in the Excel showing the Question-ids in column A and corresponding answer texts in Column Bplease help me on this,