Converting XML file to Excel spreadsheet

Hi,

Is there a way in VBA MS Excel converting XML file into readable excel file?

Hope you can give me one.

Thanks and have a great day!

You can use the ImportXml function. What version of Excel are you running?

Moved.

Hi,

Im using the office 2003. I want to export my XML file to excel but i do dont know how to do it.

Thanks!

Import it into Excel instead, using the function I posted.

Check out ImportXml in Excels VBA Help file. Theres more to it and a couple of variations if you want to use mapped cells.

Ok thanks a lot RobDog888.

Let me tyr first.