How to import multiple xml file into excel

Thanks a lot surath!!! I still have a problem !!!!!

i typed the code in an excel macro enabled spread sheet, in an inserted  module in sheet1 (developer visual basic)....

after i run the code i found the sheet1 to contain several copies of records of the one xml file only in cells (data replicated). i had four xml files in the folder but actually found more replicated cells.... of one xml file.

This is what my xml file looks like......

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

<id>4cbcaeaa-398b-4ccf-8a8a-40ad4eae01b9-1</id>

<lastModified>2014-02-03 06:24:44</lastModified>

<label>motorvehicleacc</label>

<participantsIds>

<string>cfdabbd1-860e-423b-bcf3-1b05b856cf0d</string>

</participantsIds>

<adminsIds>

<string>cfdabbd1-860e-423b-bcf3-1b05b856cf0d</string>

</adminsIds>

<productOwnersIds>

<string>cfdabbd1-860e-423b-bcf3-1b05b856cf0d</string>

</productOwnersIds>

<scrumMastersIds>

<string>cfdabbd1-860e-423b-bcf3-1b05b856cf0d</string>

</scrumMastersIds>

<teamMembersIds>

<string>cfdabbd1-860e-423b-bcf3-1b05b856cf0d</string>

</teamMembersIds>

<currentSprintId>b230844f-f0ee-4927-9406-43ce8d6932cd</currentSprintId>

<nextSprintId>7f228b2f-b620-43a4-a197-501abbecfa33</nextSprintId>

<requirementsOrderIds/>

<urgentIssuesOrderIds/>

<lastSprintNumber>2</lastSprintNumber>

<lastTaskNumber>0</lastTaskNumber>

<lastRequirementNumber>0</lastRequirementNumber>

<lastQualityNumber>0</lastQualityNumber>

<lastRiskNumber>0</lastRiskNumber>

<lastIssueNumber>1</lastIssueNumber>

<lastImpedimentNumber>0</lastImpedimentNumber>

<lastFileNumber>0</lastFileNumber>

<lastSubjectNumber>0</lastSubjectNumber>

<lastEventNumber>0</lastEventNumber>

<lastReleaseNumber>0</lastReleaseNumber>

<lastBlogEntryNumber>0</lastBlogEntryNumber>

<punishmentUnit>EUR</punishmentUnit>

<punishmentFactor>1</punishmentFactor>

<autoUpdateHomepage>false</autoUpdateHomepage>

<issueReplyTemplate>Hello ${issuer.name},

thank you very much for your feedback.

Your issue is now known as ${issue.reference}. You can view it on our homepage: ${homepage.url}/${issue.reference}.html

</issueReplyTemplate>

<subscriberNotificationTemplate>Hello,

there is news on an entity you are subscribed to:

${entity.reference} ${entity.label}

${homepage.url}/${entity.reference}.html

${change.message}

Unsubscribe from ${entity.reference}: ${unsubscribe.url}

Unsubscribe from all entities: ${unsubscribeall.url}

</subscriberNotificationTemplate>

<lastOpenedDateAndTime>2014-02-03 06:24:44</lastOpenedDateAndTime>

<freeDays>0</freeDays>

<autoCreateTasksFromQualities>false</autoCreateTasksFromQualities>

</project>

Thanks once again

Hello JIMZCE,

Thank you for your reply.

Here is  some step you can perform. please let me know the result.

if u are using Excel 2007 or 2010

Step : Click on Data from ribbon > From other sources > from XML data import > navigate to your .xml file and click on open. >ok >ok

this is the manual way to import a .xml file.

if it work for you then the macro should work.

please reply me with results. :)