Macro to export rows as individual xml files with repeating element

[silverback24]

I am putting together a workbook so that our customer service can put all the credit memos into a spreadsheet and have a macro export each row as an individual XML file. The issue I am running into is where we can have from 1 to 12 parts listed in these memos. Does anyone have any pointers for this? I will post the XML.

<sbcpartorderrequest>Nevermind the XML code only posts the data inside of it when I paste it here.

</sbcpartorderrequest><SBCPartOrderRequest>
<TrackingInfo>
<TrackNum>1234567890</TrackNum>
<SupplierName>TESTSELLER</SupplierName>
</TrackingInfo>
<BuyerInfo>
<CustomerID></CustomerID>
</BuyerInfo>
<PONum>1234567890</PONum>
<JobNumber> </JobNumber>
<Items>
<Item>
<ItemID>1</ItemID>
<WarehouseOrder>Y</WarehouseOrder>
<MfgCode>ACD</MfgCode>
<PartNum>PF59</PartNum>
<Qty>1</Qty>
<QtyOrder>1</QtyOrder>
</Item>
<Item>
<ItemID>2</ItemID>
<MfgCode>ACD</MfgCode>
<PartNum>A1519C</PartNum>
<Qty>1</Qty>
<QtyOrder>1</QtyOrder>
</Item>
</Items>
<ShipTo>
<CompanyName>ABC Auto Parts shop-2</CompanyName>
<Street>1234 Anywhere Lane</Street>
<State>IL</State>
</ShipTo>
</SBCPartOrderRequest>