Thread: Xml
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
crossplatform[_5_] crossplatform[_5_] is offline
external usenet poster
 
Posts: 1
Default Xml

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