Excel to XML

Good day all,

I am looking to convert a 2007 MS Excel file into a XML output for my AS3 project. I have tried to save as XML data and it errors stating that XML mapping is required. I also have an option to save as 2003 XML worksheet, which works but it provides its own tags and I cant get the order right. I have also attempted to add VB code to the macro screen, but I am lost in the MS world. I just need a clean consistent XML output, no formulas just cell info.

Any thoughts?

Thanks