How to import multiple xml file into excel

Hi Again, 

            Firstly as per your suggestion I've created a schema1.xml with the following contents

{code}

<?xml version="1.0" encoding="UTF-8"?>

<details>

  <movie>

    <title></title>

    <year></year>

    <releaseDate></releaseDate>

    <rating></rating>

    <plot></plot>

    <country></country>

    <runtime></runtime>

    <language></language>

    <subtitles></subtitles>

    <container></container>

    <videoCodec></videoCodec>

    <audioCodec></audioCodec>

    <audioChannels></audioChannels>

    <resolution></resolution>

    <fps></fps>

    <fileSize></fileSize>

    <genres>

      <genre></genre>

      <genre></genre>

      <genre></genre>

    </genres>

    <director></director>

    <cast>

      <actor></actor>

      <actor></actor>

      <actor></actor>

      <actor></actor>

      <actor></actor>

      <actor></actor>

      <actor></actor>

      <actor></actor>

      <actor></actor>

      <actor></actor>

    </cast>

  </movie>

</details>

{code}

This XML file imports successfully into Excel on a new active worksheet, but unfortunately I'm not able to save it again as an XML Data (*.xml) file using Excel, but I can curiously I could save it as a XML Spreadsheet 2003 (*.xml) file (I'm using Excel 2010) and naturally it could be saved as a xlsm file.

I'm not sure of your logic at this task so I haven't proceeded past this point.

Regards

S