VBA Web-Scrape From Table

[abbaddon223]

Hi - I'm hoping someone can help me please?

I need to be able to scrape some basic details from a webform and put the values into a access database.

When the fields are refferrenced by elementID's I'm okay, but in this case they are in a table - Argh!!!

The fields I'd like are Name, Address etc (very noticable for both the table ref and value from the webform source code below. Can anyone help me as it's something that always stumps me :banghead: Thank you for any support!



<table width="100%" id="maintable">
<tr class="tableheader">
<td>
<strong>Name</strong>
</td>
<td>
<strong>Address</strong>
</td>
<td>
<strong>Phone</strong>
</td>
<td>
<strong>Email</strong>
</td>
</tr>

<tr class="tableitem">
<td>Test Test</td>
<td>Mander House
Mander Centre
Wolverhampton
West Midlands
Wv1 3nh</td>
<td>
<ul>
<li>07910976049</li>
</ul>
</td>
<td></td>
</tr>
</table>

<table width="100%" id="maintable">
<tr class="tableheader">
<td>
<strong>Date Of Birth</strong>
</td>
<td>
<strong>Client has PPI</strong>
</td>
<td>
<strong>Client has been in IVA</strong>
</td>
<td>
<strong>Client has been in bankruptcy</strong>
</td>
<td>
<strong>Client is in debt man / arrears</strong>
</td>
</tr>