none
MSXML:VBA : How to get Array Index of an XML element ?

    Question

  • I have a requirement to convert the XML files to Excel. So i want to retrieve the XML as name value pairs and uniquely name the columns. 
    Is there any method to get the XML array index of a node ? Below is the sample XML where i want to know the index of productInfo fields.

    <productInfoRequest>
      <CheckIn>false</doCheckIn>
      <timeStamp>2016-11-02T15:49:57.337-05:00</timeStamp>
      <foodoInfo>
        <Country>USA</receiveCountry>
        <Currency>USD</Currency>
      </fqdoInfo>
      <productInfo>
      <itemNo>1</itemNo>
      <itemName>Sample</itemName>
      </productInfo>
      <productInfo>
      <itemNo>2</itemNo>
      <itemName>Sample</itemName>
      </productInfo> 
      <productInfo>
      <itemNo>3</itemNo>
      <itemName>Sample</itemName>
      </productInfo> 
      <productInfo>
      <itemNo>4</itemNo>
      <itemName>Sample</itemName>
      </productInfo>
      </productInfoRequest>

    • Edited by vkumar-ms Monday, April 03, 2017 9:22 PM
    Monday, April 03, 2017 9:21 PM