Need Help for creating a Macro to extract specific data from all files in a folder.

Hi,

I need help in creating a macro which will be pulling specific data from all the files available in a folder.

Sample data is:

<abc>
<bcd>aa</bcd>
<test>551348342675</test>
<xyz>
<dfg>
<testtag>551348342675</testtag>
<afda>M</afda>
<afdd>I</afdd>
<ghgf>04</ghgf>
<tess>AB</tess>


All the files in this folder have the text in the above mentioned format. This is not the whole text, there is lot more to it. I need the numbers between the <testtag> and </testtag> copied into a column on excel sheet. This text file will have more than one <testtag> entry and more than one of these numbers. I need all of them but not duplicate as the file may have duplicate entries too.

Please help.

Thanks,
Ali

Thanks for the Quick Reply.

I have attached a test file.

Thanks a lot for helping.

Ali

Thanks so much for your help.