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