Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default read data element from XML file

On Monday, August 8, 2005 at 8:24:12 PM UTC+3, Steve Moreno wrote:
I've got a Excel worksheet that needs to lookup data values in a XML file.
If the XML file is formated as such:

File_1
ParentNode1
ChildNode1
DataElement1
DataElement2
DataElement3
ChildNode2
DataElement1
DataElement2
ParentNode2
ChildNode1
DataElement1
DataElement2
DataElement3
ChildNode2
DataElement1
DataElement2

How would I lookup the data value in ParentNode2\ChildNode1\DataElement2? I
am using a reference to Microsoft XML v.4.0 in the code explorer for this
workbook.

Thanks In Advance.




Hello Steve, I have a small task I want to read XML file and insert tags as dynamic table bt macros ...

Please, any help to start Copying code that you are inserted here but not working fine I changed the path of XML file...

Thanks in advance
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Read data from anohter XLS file John Whitehead via OfficeKB.com Excel Worksheet Functions 6 July 31st 05 10:20 PM
Read data from a text file (*.txt) Adrian T Excel Programming 0 June 4th 04 10:00 PM
Read data from ascii file Nazrul Excel Programming 2 October 23rd 03 08:21 PM
VBA to read data from XL and import into another XL file Steve D[_4_] Excel Programming 0 August 28th 03 04:34 PM
Selective read data from ascii file Steve Kim Excel Programming 0 August 20th 03 05:19 AM


All times are GMT +1. The time now is 06:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"