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/2026', 'null', '0');">
A</a>
</td>
<td>
0</td>
<td>
04/01/2026</td>
<td>
</td>
<td>
ACTIVE</td>
<td>
;</td>
<td>
;</td>
<td>
S5820</td>
<td>
005</td>
<td>
N</td>
<td>
WS15687487</td>
</tr>
</table>