Extracting HTML from web based query?
 

I'm trying to extra the table information from here (more specifically,
column Month, Share, Nav)........obviously because of how it is setup I
can't do a straight up web query

http://tinyurl.com/fh8dc


It was suggested that maybe I could extract the data from the HTML on
the page
i.e.,


Code:
--------------------

<div class="ChartDataDiv"
<table class="ChartDataTable" id="Table1" cellspacing="0" cellpadding="0" border="1"
<tr
<td class="ChartDataHdr"Month End</td
<td class="ChartDataHdr"Share Price</td
<td class="ChartDataHdr"NAV</td

</tr

<tr
<td class="ChartDataCol"06/30/2005</td
<td class="ChartDataCol"$21.62</td
<td class="ChartDataCol"$24.43</td
</tr

<tr
<td class="ChartDataCol"07/31/2005</td
<td class="ChartDataCol"$22.16</td
<td class="ChartDataCol"$25.35</td
</tr

<tr
<td class="ChartDataCol"08/31/2005</td

<td class="ChartDataCol"$22.21</td
<td class="ChartDataCol"$25.43</td
</tr

<tr
<td class="ChartDataCol"09/30/2005</td
<td class="ChartDataCol"$23.40</td

<td class="ChartDataCol"$26.19</td
</tr

<tr
<td class="ChartDataCol"10/31/2005</td
<td class="ChartDataCol"$21.61</td
<td class="ChartDataCol"$24.21</td

</tr

<tr
<td class="ChartDataCol"11/30/2005</td
<td class="ChartDataCol"$21.30</td
<td class="ChartDataCol"$23.91</td
</tr

<tr
<td class="ChartDataCol"12/31/2005</td
<td class="ChartDataCol"$19.40</td
<td class="ChartDataCol"$21.18</td
</tr

<tr
<td class="ChartDataCol"01/31/2006</td

<td class="ChartDataCol"$20.66</td
<td class="ChartDataCol"$22.65</td
</tr

<tr
<td class="ChartDataCol"02/28/2006</td
<td class="ChartDataCol"$21.05</td

<td class="ChartDataCol"$22.09</td
</tr

<tr
<td class="ChartDataCol"03/31/2006</td
<td class="ChartDataCol"$21.22</td
<td class="ChartDataCol"$21.53</td

</tr

<tr
<td class="ChartDataCol"04/30/2006</td
<td class="ChartDataCol"$20.77</td
<td class="ChartDataCol"$21.87</td
</tr

<tr
<td class="ChartDataCol"05/31/2006</td
<td class="ChartDataCol"$20.95</td
<td class="ChartDataCol"$22.23</td
</tr

</table
</div

--------------------



But I'm not certain how I'd do that???


--
99atlantic
------------------------------------------------------------------------
99atlantic's Profile: http://www.excelforum.com/member.php...o&userid=31194
View this thread: http://www.excelforum.com/showthread...hreadid=552409

Extracting HTML from web based query?
 

:(....................


--
99atlantic
------------------------------------------------------------------------
99atlantic's Profile: http://www.excelforum.com/member.php...o&userid=31194
View this thread: http://www.excelforum.com/showthread...hreadid=552409