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.[TABLE="class: table table-hover"]
<thead></thead><tbody>[TR]
[TD]...[/TD]
[TD]xyz [/TD]
[TD]....[/TD]
[TD]
"5018 TEST STREET"
"
Test, TX
12345-0001
"
[/TD]
[/TR]
</tbody>[/TABLE]
</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.Title
It normally gives me an object error and it cannot find the address.[TABLE="class: table table-hover"]
<thead></thead><tbody>[TR]
[TD]...[/TD]
[TD]xyz [/TD]
[TD]....[/TD]
[TD]
"5018 TEST STREET"
"
Test, TX
12345-0001
"
[/TD]
[/TR]
</tbody>[/TABLE]
</div>