Im trying to pull in the data from
the name address and location. I was trying this code but only seems to load page and not pull the info to excel
I have a excel sheet with the parcel 017-01-009-154 for this example.
i want it to take the info from A2 and put name in B2, Address in C2, City and state in D2.
and work its way down the list.
Sub test()
Dim ie As New InternetExplorer
Dim doc As New HTMLDocument
Dim ecoll As Object
ie.Visible = True
ie.navigate "Web Table Elements"
Do
DoEvents
Loop Until ie.readyState = READYSTATE_COMPLETE
Set doc = ie.document
Set ecoll = doc.getElementsByTagName("table")
End Sub
if possible trying to get it so does not open each one in its own browser, may just updates in background.
but i can not even get it to put anything in excel.
' IE and OutLook
Dim NorryLink As String
' Link to copy Print Screen
NorryLink = "Home - County of Northumberland" & Sheets("Tax Cert Bill").Range("B17").Value
i would need to have code updated so just does not look at B17 but at A2 and down
Home - County of Northumberland
tax.norrycopa.net
the name address and location. I was trying this code but only seems to load page and not pull the info to excel
I have a excel sheet with the parcel 017-01-009-154 for this example.
i want it to take the info from A2 and put name in B2, Address in C2, City and state in D2.
and work its way down the list.
Sub test()
Dim ie As New InternetExplorer
Dim doc As New HTMLDocument
Dim ecoll As Object
ie.Visible = True
ie.navigate "Web Table Elements"
Do
DoEvents
Loop Until ie.readyState = READYSTATE_COMPLETE
Set doc = ie.document
Set ecoll = doc.getElementsByTagName("table")
End Sub
if possible trying to get it so does not open each one in its own browser, may just updates in background.
but i can not even get it to put anything in excel.
' IE and OutLook
Dim NorryLink As String
' Link to copy Print Screen
NorryLink = "Home - County of Northumberland" & Sheets("Tax Cert Bill").Range("B17").Value
i would need to have code updated so just does not look at B17 but at A2 and down