Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

How to get past TXLife element in an ACORD XML file

How to get past TXLife element in an ACORD XML file

How to get past TXLife element in an ACORD XML file

I am trying to parse a XML file transmitted in ACORD format.  XML files in this format have a standard first, 'root' element of TXLife.  These files then have an element named OLifE, where child nodes under it contain all the data particular to the file.  My problem is, when attempting to loop thru my file, my code stops after looping thru the TXLife element and does not continue thru the childnodes under OLifE, where my data is.

Does anyone have experience parsing a ACORD standard XML file?  Once I get into the OLifE nodes, I believe I can get the data I want.  I am using VBA, behind an MSAccess 2007 form.  Using XML 4.0 reference.  Thanks for any help you can provide.  A snippet of my code is:

Dim myXMLDoc As MSXML2.DOMDocument40
Set myXMLDoc = New MSXML2.DOMDocument40
Dim ClaimList As IXMLDOMNodeList
Dim MyItem As IXMLDOMElement
Dim MyChild As IXMLDOMElement

Dim varA As String, varB As String

myXMLDoc.Load ("H:\aaaaa.xml")
Set ClaimList = myXMLDoc.documentElement.ChildNodes

For Each MyItem In ClaimList
   For Each MyChild In MyItem.ChildNodes
        varA = MyChild.nodeName
        varB = MyChild.Text

Set myXMLDoc = Nothing
Set ClaimList = Nothing

Replies continue below

Recommended for you

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close