Cass
11-20-2005, 05:15 AM
Is any way to get data from xml file without import the file.
this code must be:
1. search specified ID and get data ( index and RoleID number)
<Player ID="44801548" Index="1">
<PlayerID>44801548</PlayerID>
<RoleID>2</RoleID>
</Player>
2. output this data to table
3. loop next ID and get also data which is this Player id section
Primary problem is how get data from xml file.
I dont want import because there are ~20 xml file and loop through all files http://vbaexpress.com/forum/images/smilies/rotlaugh.gif
this code must be:
1. search specified ID and get data ( index and RoleID number)
<Player ID="44801548" Index="1">
<PlayerID>44801548</PlayerID>
<RoleID>2</RoleID>
</Player>
2. output this data to table
3. loop next ID and get also data which is this Player id section
Primary problem is how get data from xml file.
I dont want import because there are ~20 xml file and loop through all files http://vbaexpress.com/forum/images/smilies/rotlaugh.gif