sample XML:
<Batch BatchID="126"
<Doc DocNmb="1" DocType="8AForm_Tmpl" DocStatus="One-page rul
error"
<Page PageNmb="1" PageType="Form8A_2Tmpl" PageStatus="One-pag
rule error"
<Field FieldName="Employee code"F97</Field
<Field FieldName="Year"2001</Field
With blockNodes
For i = 0 To .length - 1
var = .Item(i).Text
Next i
End With
.Item(i).Text gives me "F97" and "2001"
but what I need is "Employee code" and "Year"
any suggestion
--
Message posted from
http://www.ExcelForum.com