Referencing A Value In Source Code (1 Viewer)

abbaddon223

Registered User.
Local time
Today, 15:49
Joined
Mar 13, 2010
Messages
162
Hi there,

I am very new to web scraping with VBA through Access. I'm using a form in an db which has some VBA in. This is accessing a portal from which I am putting data from the form into the portal, running a query, then needing to get some data back from the portal to my form.

I've been doing this by referencing the source code ID for the fields I want, but have hit a stumbling block that I hope someone can help me with please?

When the query in the portal runs, it shows the results in a table for which I expected to find a source code ID for. It doesn't :mad:

What is does show is the below. The headings I want to get the data from are:

Heading: [Service Type]
The value I want to get: "WLR3 ISDN 30 DASS"

Please see below for further comments

<divclass="subSectionLeft"style="width: 50%;">
<divclass="subSection">
<h4class="subHeader">
Line Details</h4>
<tableclass="detailsTable">
<trclass="TableRow">
<tdclass="TableCell">
Service ID:
</td>
<tdclass="AltTableCell">
01992632222
</td>
</tr>
<trclass="TableRow">
<tdclass="TableCell">
Telephone number:
</td>
<tdclass="AltTableCell">
0199263****
</td>
</tr>
<trclass="TableRow">
<tdclass="TableCell">
Postcode:
</td>
<tdclass="AltTableCell">
EN8 ***
</td>
</tr>
<trclass="TableRow">
<tdclass="TableCell">
Service type:
</td>
<tdclass="AltTableCell">
WLR3 ISDN 30 DASS
</td>
</tr>
<trclass="TableRow">
<tdclass="TableCell">
Channel quantity:
</td>
<tdclass="AltTableCell">
30
</td>
</tr>
<trclass="TableRow">
<tdclass="TableCell">
Care level:
</td>
<tdclass="AltTableCell">
4

If someone can help, then hopefully I can just replicate the syntax to get the rest. Thank you in advance for any help!!
 

Users who are viewing this thread

Top Bottom