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
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!!
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
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!!