Hi,
I'm sorry if the title isn't correct, I think that's what I'm trying to do is called...
Anywho, I have some XML code that contains a bunch of data that I need to extract and place in another cell / sheet.

The XML code will look something like this:

<Customer><CashOnly>false </CashOnly><ApplicationID>31</ApplicationID>
<ProductID>41 </ProductID>
<ReconnectService>false </ReconnectService>
<AddressLine1>1111 BLAKEWOOD PL </AddressLine1>
<Password>5123 </Password>
<ServerACK>OK </ServerACK>
<HomePhoneNumber>9015551234 </HomePhoneNumber>
<AccountNumber>0001234567890123 </AccountNumber>
<MessageID>310809121620316889 </MessageID>
<XMLTimeStamp>1899-12-30T00:00:00 </XMLTimeStamp>
<FirstName>JOHN DOE  </FirstName>
<CombinedBilling>Y </CombinedBilling>
<CurrentAmountDue>0 </CurrentAmountDue>
<PastAmountDue>241.87 </PastAmountDue>
<TotalAmountDue>241.87 </TotalAmountDue>
<BillDueDate>1899-12-30T00:00:00 </BillDueDate>
<VendorResponseCode>00 </VendorResponseCode>
<IFTResponseCode>0 </IFTResponseCode>
<TransactionFeeAmount>2 </TransactionFeeAmount>
<KioskID>11123 </KioskID>
<TransactionID>0 </TransactionID></Customer>
What I need to do is write a macro that can pull things like the account number out of here:
<AccountNumber>0001234567890123 </AccountNumber>
The numbers can be in different places throughout this code, and the code is rarely the same, but it follows the same patterns of placing these numbers between labels like that.

I've got agents that have ot extract this information manually and it takes too much time.

If anyone can point me in the right direction (and be a little patient with me :P) I'd really appreciate it.