Web Scrape To Excel VBA: JAVA Site

Hello Fellow Forumers!

I have bitten off a bit of a challenging(in my opinion) project where I'd like to query a website(list of addresses in excel pre-populated by myself) and "copy paste" back into excel. I started to follow a youtube tutorial online but realized that its tough to modify the url I believe if its made in Java. I dont have much experience but am usually good following tutorials and modifying to my case. What I'd like to do:
Steps:
1) Navigate https://wwwnet1.state.nj.us/Treasury...istSearch.aspx
2) Enter Address from cells in the L column and enter into "Property Location" on the website
3) When result(s) are displayed then click/navigate to "View"
4) On view I'd like to match the data from the inquiry ONLY to the Bolded columns and repeat this all the way down the L column
*If more than one result is displayed on step 3 I'd like to choose the first one.

If anyone thinks they can take over my VBA I started or start fresh I'd so so so appreciate it! This is my first web scrape project and I'd love to be able to learn from this to apply to other cases(expecially if it IS JAVA and its more difficult than most)

Thanks!

Does anyone have experience with this?

Maybe someone has good success with hiring someone to make a web scrape VBA code?

Hi !

See Web Scraping archives and many samples in this forum as well …

Trying to write a code for web scraping the weather off the website there is forecast data in a table I am not able to get. Run-time error '438 keeps coming up. Any recommendations on how I can fix this issue?

tSpan = Doc.getElementById("Forecast").getElementById("fctday-20160719")
'.getElementsByClassName("hi").innerText


Code

Sub Weather_Scrape()
Dim counter As Integer
Dim Doc As HTMLDocument
counter = 0
Dim zipcodes As Range
Set zipcodes = Range("D5:D30")
'For each: in zipcodes then do a webscrape
Dim IE As New InternetExplorer
IE.Visible = True
Dim sSpan As String
Dim tSpan As String
Dim dd As HTMLDocument

' For Each i In zipcodes
' If i <> "" Then
' IE.navigate "https://www.wunderground.com/cgi-bin/findweather/getForecast?query=" & i.Value
' Do
' DoEvents
' Loop Until IE.readyState = READYSTATE_COMPLETE
' Set Doc = IE.document
' sSpan = Doc.getElementById("curTemp").innerText
' Range("E5").Offset(counter, 0) = sSpan
' counter = counter + 1
' End If

' Next i
' counter = 0
For Each i In zipcodes
If i <> "" Then
IE.navigate "https://www.wunderground.com/cgi-bin/findweather/getForecast?query=" & i.Value
Do
DoEvents
Loop Until IE.readyState = READYSTATE_COMPLETE
Set Doc = IE.document

Range("F5").Offset(counter, 0) = tSpan
counter = counter + 1
End If
Next i

IE.Quit

End Sub