I am attempting to grab pieces of address info off a website however, I'm not able to grab the correct data:
I want to be able to grab the Street as on variable, city and state as another, and finally the zip.
Here is the html code I am trying to scrape:
I'm trying to grab 5018 Test street and place in one cell and then Test, Tx in one cell, and 12345-0001 in on cell.
Here is my vba code:
It normally gives me an object error and it cannot find the address.
<thead></thead><tbody>
</tbody></div>
I want to be able to grab the Street as on variable, city and state as another, and finally the zip.
Here is the html code I am trying to scrape:
HTML:
==$0
...I'm trying to grab 5018 Test street and place in one cell and then Test, Tx in one cell, and 12345-0001 in on cell.
Here is my vba code:
Code:
Set myElement = objIE.document.getElementsByClassName("col-lg-12")(0)If Not myElement Is Nothing Then
Do While objIE.Busy = True Or objIE.readyState <> 4: DoEvents: Loop
Application.Wait (Now + #12:00:02 AM#)
WS.Cells(r + 1, 3).Value = myElement.TitleIt normally gives me an object error and it cannot find the address.
| ... | xyz | .... | "5018 TEST STREET" " Test, TX 12345-0001 " |
<thead></thead><tbody>
</tbody>
