Hi,
I connect to a web service, and it returns a IXMLDOMNodeList type variable. It looks as though the node list's item(0) contains the schema, and item(1) contains all the table data.
How can I transfer this data into the excel spreadsheet?
This is what it returns when I debug.print results.item(0).xml (results is the results of the web service in IXMLDOMNodeList type)
<xs:schema id="NewDataSet" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns="" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"><xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:MainDataTable="v" msdata:UseCurrentLocale="true"><xs:complexType><xs:choice minOccurs="0" maxOccurs="unbounded"><xs:element name="v"><xs:complexType><xs:sequence><xs:element name="c0" msdata:Caption="Tag1" type="xs:string" minOccurs="0"/><xs:element name="c1" msdata:Caption="Tag2" type="xs:string" minOccurs="0"/><xs:element name="c2" msdata:Caption="Tag3" type="xs:string" minOccurs="0"/><xs:element name="c3" msdata:Caption="Tag4" type="xs:string" minOccurs="0"/><xs:element name="c4" msdata:Caption="Tag5" type="xs:string" minOccurs="0"/><xs:element name="c5" msdata:Caption="Tag6" type="xs:string" minOccurs="0"/><xs:element name="c6" msdata:Caption="Tag7" type="xs:string" minOccurs="0"/><xs:element name="c7" msdata:Caption="Tag8" type="xs:string" minOccurs="0"/><xs
:element name="c8" msdata:Caption="Tag9" type="xs:string" minOccurs="0"/><xs:element name="c9" msdata:Caption="Tag10" type="xs:string" minOccurs="0"/><xs:element name="c10" msdata:Caption="Tag11" type="xs:string" minOccurs="0"/><xs:element name="c11" msdata:Caption="Tag12" type="xs:string" minOccurs="0"/><xs:element name="c12" msdata:Caption="Tag13" type="xs:string" minOccurs="0"/><xs:element name="c13" msdata:Caption="Tag14" type="xs:string" minOccurs="0"/><xs:element name="c14" msdata:Caption="Tag15" type="xs:string" minOccurs="0"/><xs:element name="c15" msdata:Caption="Tag16" type="xs:string" minOccurs="0"/><xs:element name="c16" msdata:Caption="Tag17" type="xs:string" minOccurs="0"/><xs:element name="c17" msdata:Caption="Tag18" type="xs:string" minOccurs="0"/><xs:element name="c18" msdata:Caption="Tag19" type="xs:string" minOccurs="0"/><xs:element name="c19" msdata:Caption="Tag20" type="xs:string" minOccurs="0"/><xs:element name="c20" msdata:Caption="Tag21" type="xs:string" minOccurs="0"/><xs:element name="c21" type="xs:string" minOccurs="0"/></xs:sequence></xs:complexType></xs:element></xs:choice></xs:complexType></xs:element></xs:schema>
This is what it returns when I debug.print results.item(1).xml (results is the results of the web service in IXMLDOMNodeList type)
<diffgr:diffgram xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"><DocumentElement xmlns="">
<v diffgr:id="v1" msdata:rowOrder="0"><c0>DATA1A</c0><c1>DATA2A</c1><c2>DATA3A</c2><c3>DATA4A</c3><c4>DATA5A</c4><c5>DATA6A</c5><c6>DATA7A</c6><c7>DATA8A</c7><c8>DATA9A</c8><c9>DATA10A</c9><c10>DATA11A</c10><c11>DATA12A</c11><c12/><c13>DATA14A</c13><c14>DATA15A</c14><c15>DATA16A</c15><c16/><c17>DATA18A</c17><c18>DATA19A</c18><c19/><c20/><c21>74977LBH9</c21></v>
<v diffgr:id="v2" msdata:rowOrder="1"><c0>DATA1B</c0><c1>DATA2B</c1><c2>DATA3B</c2><c3>DATA4B</c3><c4>DATA5B</c4><c5>DATA6B</c5><c6>DATA7B</c6><c7>DATA8B</c7><c8>DATA9B</c8><c9>DATA10B</c9><c10>DATA11B</c10><c11>DATA12B</c11><c12/><c13>DATA14B</c13><c14>DATA15B</c14><c15>DATA16B</c15><c16/><c17>DATA18B</c17><c18>DATA19B</c18><c19/><c20/><c21>74977LBH9</c21></v>
<v diffgr:id="v3" msdata:rowOrder="2"><c0>DATA1C</c0><c1>DATA2C</c1><c2>DATA3C</c2><c3>DATA4C</c3><c4>DATA5C</c4><c5>DATA6C</c5><c6>DATA7C</c6><c7>DATA8C</c7><c8>DATA9C</c8><c9>DATA10C</c9><c10>DATA11C</c10><c11>DATA12C</c11><c12/><c13>DATA14C</c13><c14>DATA15C</c14><c15>DATA16C</c15><c16/><c17>DATA18C</c17><c18>DATA19C</c18><c19/><c20/><c21>74977LBH9</c21></v>
</DocumentElement></diffgr:diffgram>
This is really driving me NUTS! Any suggestions will be great. Thanks!