Question on XPath and XML File

[batteam]

I am using XPath to parse a large ACORD XML file and have the following line of code:

...
...
Doc.SetProperty "SelectionLanguage", "XPath"
For Each XXXXX In Doc.SelectNodes("/TXLife/xx/xx[@AppliesToPartyID = 'INS_1_L98047']")
...
...

My question is, I need to substitute a variable e.g. varC that would equal 'INS_1_L98047' instead of placing the literal in the code and I cannot figure out the syntax to get it to work. Any ideas or assistance on this would be appreciated.

 

[batteam]

I have discovered the correct syntax. What worked for me is:

Doc.SetProperty "SelectionLanguage", "XPath"
For Each XXXXXX In Doc.SelectNodes("/TXLife/xx/xx[@AppliesToPartyID = '" & varC & "']")

 

[kishmbee]

You helped me in parsing my ACORD XML file. Thanks mate.