Steps:

1. Just the Open the Excel file
2. Press Alt+F11 and double click on Module 1 and change the Path in script page suit to u
3. Next, go back to excel file & press Alt + F8 and select XMLFile and click on Run

it will create a XML file in that path which u have assign