How to PArse an XML file with VBA

[jake007]

I am attempting to parse and XML file with MSXML2.DOMDocument60. I am very new to xml and am in need of some direction. I am using MSXML2.DOMDocument60, but have no idea where to begin. Mainly, I am trying to gather the commodity information from the xml file below. It is contained in the order_item node below. Any direction on this would be greatly appreciated. Here is the xml


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

http://www.mtivity.com/JobTicket">

<ORDER>
<ORDER_DATE>2011-11-11</ORDER_DATE>
<ORDER_TYPE>Catalog Order</ORDER_TYPE>
<ORDER_NAME>Sticker Samples</ORDER_NAME>
<ORDER_NUMBER>UGQTNH-3664</ORDER_NUMBER>
<ORDER_REFERENCE></ORDER_REFERENCE>
<TOTAL_ORDER_ITEMS>3</TOTAL_ORDER_ITEMS>
<ORDER_PRICE>1.5</ORDER_PRICE>
<ORDER_ITEM>
<ORDER_ITEM_ID>285645</ORDER_ITEM_ID>
<ORDER_ITEM_CODE>F2311</ORDER_ITEM_CODE>
<ORDER_ITEM_NAME>Fram Walmart Hotline Stickers</ORDER_ITEM_NAME>
<ORDER_ITEM_DESCRIPTION>Stickers</ORDER_ITEM_DESCRIPTION>
<ORDER_ITEM_QUANTITY>1</ORDER_ITEM_QUANTITY>
<ORDER_ITEM_PRICE>.25</ORDER_ITEM_PRICE>
<FILES>
<FILE>
<NAME>picture_unavailable-72115.jpg</NAME>
</FILE>
</FILES>
</ORDER_ITEM>
<ORDER_ITEM>
<ORDER_ITEM_ID>285646</ORDER_ITEM_ID>
<ORDER_ITEM_CODE>888-553-FRAM</ORDER_ITEM_CODE>
<ORDER_ITEM_NAME>Walmart Hotline Stickers</ORDER_ITEM_NAME>
<ORDER_ITEM_DESCRIPTION>Stickers</ORDER_ITEM_DESCRIPTION>
<ORDER_ITEM_QUANTITY>1</ORDER_ITEM_QUANTITY>
<ORDER_ITEM_PRICE>.25</ORDER_ITEM_PRICE>
<FILES>
<FILE>
<NAME>picture_unavailable-72115.jpg</NAME>
</FILE>
</FILES>
</ORDER_ITEM>
<ORDER_ITEM>
<ORDER_ITEM_ID>285647</ORDER_ITEM_ID>
<ORDER_ITEM_CODE>MIR $4</ORDER_ITEM_CODE>
<ORDER_ITEM_NAME>Fram Oil &amp; Air $4 MIR Stickers (100/Roll) Good thr</ORDER_ITEM_NAME>
<ORDER_ITEM_DESCRIPTION>Stickers</ORDER_ITEM_DESCRIPTION>
<ORDER_ITEM_QUANTITY>1</ORDER_ITEM_QUANTITY>
<ORDER_ITEM_PRICE>1</ORDER_ITEM_PRICE>
<FILES>
<FILE>
<NAME>picture_unavailable-72115.jpg</NAME>
</FILE>
</FILES>
</ORDER_ITEM>
<SHIPPING_NOTES></SHIPPING_NOTES>
<SHIP_TO>
<SHIP_COMPANY>ABC Company</SHIP_COMPANY>
<SHIP_CONTACT>John Q Public</SHIP_CONTACT>
<SHIP_TELEPHONE>763-555-4124</SHIP_TELEPHONE>
<SHIP_ADDRESS>
<ADDRESS_1>1985 Douglas Drive north</ADDRESS_1>
<ADDRESS_2>MN10-191B</ADDRESS_2>
<ADDRESS_3></ADDRESS_3>
<ADDRESS_CITY>Golden Valley</ADDRESS_CITY>
<ADDRESS_STATE>MN</ADDRESS_STATE>
<ADDRESS_ZIP>55422</ADDRESS_ZIP>
<ADDRESS_COUNTRY>USA</ADDRESS_COUNTRY>
</SHIP_ADDRESS>
</SHIP_TO>
</ORDER>
<MTIVITY>
<JOB_ID>275599</JOB_ID>
<JOB_NAME>Sticker Samples</JOB_NAME>
<JOB_NUMBER>09888/</JOB_NUMBER>
<ORDER_ITEM>
<ORDER_ITEM_ID>285645</ORDER_ITEM_ID>
<ORDER_ITEM_STATUS></ORDER_ITEM_STATUS>
<ORDER_ITEM_SHIPPED_QTY></ORDER_ITEM_SHIPPED_QTY>
<ORDER_ITEM_SHIPPED_DATE></ORDER_ITEM_SHIPPED_DATE>
<ORDER_ITEM_SHIPPED_ADDRESS></ORDER_ITEM_SHIPPED_ADDRESS>
<ORDER_ITEM_SHIPPED_REFERENCE></ORDER_ITEM_SHIPPED_REFERENCE>
<ORDER_ITEM_SHIPPING_COMPLETE></ORDER_ITEM_SHIPPING_COMPLETE>
</ORDER_ITEM>
<ORDER_ITEM>
<ORDER_ITEM_ID>285646</ORDER_ITEM_ID>
<ORDER_ITEM_STATUS></ORDER_ITEM_STATUS>
<ORDER_ITEM_SHIPPED_QTY></ORDER_ITEM_SHIPPED_QTY>
<ORDER_ITEM_SHIPPED_DATE></ORDER_ITEM_SHIPPED_DATE>
<ORDER_ITEM_SHIPPED_ADDRESS></ORDER_ITEM_SHIPPED_ADDRESS>
<ORDER_ITEM_SHIPPED_REFERENCE></ORDER_ITEM_SHIPPED_REFERENCE>
<ORDER_ITEM_SHIPPING_COMPLETE></ORDER_ITEM_SHIPPING_COMPLETE>
</ORDER_ITEM>
<ORDER_ITEM>
<ORDER_ITEM_ID>285647</ORDER_ITEM_ID>
<ORDER_ITEM_STATUS></ORDER_ITEM_STATUS>
<ORDER_ITEM_SHIPPED_QTY></ORDER_ITEM_SHIPPED_QTY>
<ORDER_ITEM_SHIPPED_DATE></ORDER_ITEM_SHIPPED_DATE>
<ORDER_ITEM_SHIPPED_ADDRESS></ORDER_ITEM_SHIPPED_ADDRESS>
<ORDER_ITEM_SHIPPED_REFERENCE></ORDER_ITEM_SHIPPED_REFERENCE>
<ORDER_ITEM_SHIPPING_COMPLETE></ORDER_ITEM_SHIPPING_COMPLETE>
</ORDER_ITEM>
</MTIVITY>
</JOB_TICKET>

 

[MazeWorX]

I think you ll find your answer here

http://www.tek-tips.com/viewthread.cfm?qid=1444524

scroll to the bottom of the posting the complete function is there

HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work" <<Edison>>