Noone is going to write the code for you. You have to write it yourself and when you get stuck, you can ask specific questions. Excel 2003 and above will already import XML data without any code from you. All you have to do is File, Open... But, if you have to write the code to do this, you'll need to brush up on reading an XML file, parsing the data, and doing Excel Interop. There are various ways of reading an XML file. If the number of records is not known, but can be large, then an XmlReader[^] would probably be appropriate. There's tons of example of doing Excel Interop on the web. The problem is the Excel object model isn't exactly the easiest thing to learn. All you have to do is Google for "vb.net excel interop[^]".
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007