Hi Papusale

just make that attached file as your Macro Tool..

1. Just copy your original Data and dump in that attached file (Sheet1 Tab) as per header.
2. don't rename the 1st tab.
3. Next run the macro that's it

Note: that Invalid Letters should not be there if there then xml file will not create properly

if you got your solution please mark the spread as SOLVED and click on * Add Reputation to say thanks don't forget