Microsoft Excel - Urgent Help:: VBA TD TR HTML Tags

Asked By Rajender Prasad on 27-May-13 11:30 AM
Dear All, I have something from html source as below.

Bold and underlined are the headingins.
Just bolded are the values of the headings respectively.

I want to capture the same using vba..ex: Status is Active..

I want to know, whether Status is Active or something else..

How can I do this.. please help.. Thanks ton in advance.



<tr valign="top">
    <td colspan="3"><table width='100%' border="0" cellspacing="0" cellpadding="1">
    <tr>
   <td class="listsubhead">PLAN SUMMARY</td>
      <td class="listsubhead" nowrap align="right">        
               </td>
    </tr>
    </table> <table border='0' cellpadding='3' cellspacing='0' width='100%' class='softresults'>
<tr class='listhead'>
<td>
Plan</td>
<td>
Copay</td>
<td>
Effective Date</td>
<td>
Termination Date</td>
<td>
Status</td>
<td>
Status Reason</td>
<td>
Conservation Reason</td>
<td>
Contract</td>
<td>
PBP</td>
<td>
Passport</td>
<td>
Image #</td>
<td>
Functions</td>
</tr>
 
<tr  class='tiny'  >
<td>
<a class='pwLinkBig' href="javascript:getBenefits('57', '04/01/2013', 'null', '0');">
A</a>
</td>
<td>
0</td>
<td>
04/01/2013</td>
<td>
&nbsp;</td>
<td>
ACTIVE</td>
<td>
&nbsp;</td>
<td>
&nbsp;</td>
<td>
S5820</td>
<td>
005</td>
<td>
N</td>
<td>
WS15687487</td>
</tr>
 </table>
Harry Boughen replied to Rajender Prasad on 27-May-13 05:08 PM
Hello Prasad,
One way would be to recover the whole table from the web site and then just work inside Excel.
This site has code to do this sort of data recovery.
http://www.vbaexpress.com/kb/getarticle.php?kb_id=576
Regards
Harry