Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using XmlImport to get dynamic data in Excel 2003
Hi,
I am using XmlImport method Excel 2003. I am able to import the XML file. But my requirement is to get particular part in xml file instead of full xml content. In my example i have XML which is hierarchical structure and contains resource information for different jobs. I am interested in showing only resource information for particular jobId. Please let me know how can parameterise and get resource data for desired job. My sample XML looks as shown below. <Resource_Details <job id="1" <resource <!-- some data here -- </resources </job <job id="2" <resource <!-- some data here -- </resources </job </Resource_Details Thanks and Regards, Gokul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XMLImport problem | Excel Discussion (Misc queries) | |||
XmlImport Problem in Excel 2007 | Excel Discussion (Misc queries) | |||
ActiveWorkbook.XmlImport? | Excel Programming | |||
Dynamic web query in Excel 2003 | Excel Discussion (Misc queries) | |||
Using XmlImport/Export Fucntions for excel | Excel Programming |