不懂VB啊,但现在着急用。需用用VB读取某XML文件中的部分数据,XML文件如下:
_____________________________
<?xml version="1.0" encoding="utf-8" ?>
- <page>
- <etTimes>
- <etTime id="cn" status="closed">
<time display0="Friday, May 18, 2007, 6:01pm ET">2007-05-18T18:01:36+08:00</time>
<status>closed</status>
</etTime>
</etTimes>
- <settings page="summary">
- <columnarViews>
- <columnarView id="e">
<name>实时ECN</name>
</columnarView>
- <columnarView id="v1">
<name>对比栏</name>
</columnarView>
</columnarViews>
- <sections>
<section id="summary_quote_equity" />
<section id="business_summary" />
</sections>
</settings>
- <portfolio>
- <entry>
<symbol>601988.SS</symbol>
</entry>
</portfolio>
- <financialInstruments>
- <equity symbol="601988.SS">
<symbol datum_id="s00">601988.SS</symbol>
<displaySymbol datum_id="s20">601988.SS</displaySymbol>
<exchange datum_id="x00">SHH</exchange>
<priceFormat>#,##0.00#</priceFormat>
<currency datum_id="c01" />
- <quote>
- <ask datum_id="a03">
<price datum_id="a00">5.820000</price>
</ask>
- <bid datum_id="b03">
<price datum_id="b00">5.810000</price>
</bid>
- <change datum_id="c00">
<absolute datum_id="c10">-0.100000</absolute>
<percent datum_id="p20">-1.692046</percent>
</change>
- <last contributor="rts" datum_id="l00">
<size datum_id="k30">0</size>
<value datum_id="l10">5.810000</value>
<nvalue>5.810000</nvalue>
<time datum_id="t10" display0="3:00pm ET" display1="May 18" display2="May 18, 2007">2007-05-18T15:00:00+08:00</time>
</last>
- <ranges>
- <range datum_id="m00" duration="1d">
<high datum_id="h00">5.880000</high>
<low datum_id="g00">5.790000</low>
</range>
</ranges>
<open datum_id="o00">5.880000</open>
<previousClose datum_id="p00">5.910000</previousClose>
<volume datum_id="v00">204348533</volume>
</quote>
- <financialData>
<eps datum_id="e00">0.000000</eps>
</financialData>
- <links datum_id="i00">
<link id="summary" />
<link id="fullquote" />
<link id="historical" />
</links>
- <shares>
<sharesOut datum_id="j20">N/A</sharesOut>
</shares>
- <name>
<long country="cn" datum_id="n60" lang="zh">中国银行</long>
</name>
- <links datum_id="i00">
<link id="profile_cn" />
<link id="keystats_cn" />
</links>
</equity>
</financialInstruments>
</page>
_____________________________
该XML文件的URL地址是 www.sss.com/s=601988
麻烦谁写段代码把里面的
<ask datum_id="a03">
<price datum_id="a00">5.820000</price> ----只取5.820000
</ask>
- <bid datum_id="b03">
<price datum_id="b00">5.810000</price> -----只取5.810000
</bid>
和<long country="cn" datum_id="n60" lang="zh">中国银行</long>中的中国银行
这3个数值,把这3个数值分别存到strA、strB、strC中
..非常感谢!!!
这段脚本主要是用在自动化测试工具QTP上...
_____________________________
<?xml version="1.0" encoding="utf-8" ?>
- <page>
- <etTimes>
- <etTime id="cn" status="closed">
<time display0="Friday, May 18, 2007, 6:01pm ET">2007-05-18T18:01:36+08:00</time>
<status>closed</status>
</etTime>
</etTimes>
- <settings page="summary">
- <columnarViews>
- <columnarView id="e">
<name>实时ECN</name>
</columnarView>
- <columnarView id="v1">
<name>对比栏</name>
</columnarView>
</columnarViews>
- <sections>
<section id="summary_quote_equity" />
<section id="business_summary" />
</sections>
</settings>
- <portfolio>
- <entry>
<symbol>601988.SS</symbol>
</entry>
</portfolio>
- <financialInstruments>
- <equity symbol="601988.SS">
<symbol datum_id="s00">601988.SS</symbol>
<displaySymbol datum_id="s20">601988.SS</displaySymbol>
<exchange datum_id="x00">SHH</exchange>
<priceFormat>#,##0.00#</priceFormat>
<currency datum_id="c01" />
- <quote>
- <ask datum_id="a03">
<price datum_id="a00">5.820000</price>
</ask>
- <bid datum_id="b03">
<price datum_id="b00">5.810000</price>
</bid>
- <change datum_id="c00">
<absolute datum_id="c10">-0.100000</absolute>
<percent datum_id="p20">-1.692046</percent>
</change>
- <last contributor="rts" datum_id="l00">
<size datum_id="k30">0</size>
<value datum_id="l10">5.810000</value>
<nvalue>5.810000</nvalue>
<time datum_id="t10" display0="3:00pm ET" display1="May 18" display2="May 18, 2007">2007-05-18T15:00:00+08:00</time>
</last>
- <ranges>
- <range datum_id="m00" duration="1d">
<high datum_id="h00">5.880000</high>
<low datum_id="g00">5.790000</low>
</range>
</ranges>
<open datum_id="o00">5.880000</open>
<previousClose datum_id="p00">5.910000</previousClose>
<volume datum_id="v00">204348533</volume>
</quote>
- <financialData>
<eps datum_id="e00">0.000000</eps>
</financialData>
- <links datum_id="i00">
<link id="summary" />
<link id="fullquote" />
<link id="historical" />
</links>
- <shares>
<sharesOut datum_id="j20">N/A</sharesOut>
</shares>
- <name>
<long country="cn" datum_id="n60" lang="zh">中国银行</long>
</name>
- <links datum_id="i00">
<link id="profile_cn" />
<link id="keystats_cn" />
</links>
</equity>
</financialInstruments>
</page>
_____________________________
该XML文件的URL地址是 www.sss.com/s=601988
麻烦谁写段代码把里面的
<ask datum_id="a03">
<price datum_id="a00">5.820000</price> ----只取5.820000
</ask>
- <bid datum_id="b03">
<price datum_id="b00">5.810000</price> -----只取5.810000
</bid>
和<long country="cn" datum_id="n60" lang="zh">中国银行</long>中的中国银行
这3个数值,把这3个数值分别存到strA、strB、strC中
..非常感谢!!!
这段脚本主要是用在自动化测试工具QTP上...
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货