Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jan 2007
    Location
    Massachusetts, USA
    Posts
    272
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Macro/Script needed to extract certain XML tag (element) data out and put into Excel Spreadsheet

    Hi all,

    I am trying to see if there is a script that can do the following:

    1. Point to a folder full of XML files.
    2. Find each XML spare part name, manufacturer code, part number and quantity (see sample below)

    -----------------------------------------------------------------------------------------
    <reqSpares>
    <spareDescrGroup>
    <spareDescr id="spa-0001">
    <name>Handlebar</name>
    <identNumber>
    <manufacturerCode>KZ555</manufacturerCode>
    <partAndSerialNumber>
    <partNumber>Hd-001</partNumber>
    </partAndSerialNumber>
    </identNumber>
    <reqQuantity unitOfMeasure="EA">1</reqQuantity>
    </spareDescr>
    </spareDescrGroup>
    </reqSpares>

    ------------------------------------------------------------------------------------

    3. List out all the XML tag (element) entries found, into a spreadsheet in columns for:

    Name
    Manufacturer Code
    Part Number
    Quantity



    Any ideas on how to make this happen is very much appreciated.


    Regards,

    Jim

  2. #2
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,633
    Thanks
    115
    Thanked 647 Times in 590 Posts
    I am sure you will find a script to do what you want in this XML potpourri

    http://windowssecrets.com/forums/sho...les-into-Excel

  3. #3
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts
    james: I see you've asked essentially the same question in http://windowssecrets.com/forums/sho...ticolumn-table
    Kindly read Rule #16 - http://windowssecrets.com/forums/faq...ision#flooding
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  4. #4
    3 Star Lounger
    Join Date
    Jan 2007
    Location
    Massachusetts, USA
    Posts
    272
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Thank you Maudibe. I will check it out.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •