Hi Excel Gurus,
I am trying to retrieve all the links from site The Finder - Individual County Boundary Data
After going into URL, I want to click each alphabet
When clicking 'A' , I want to get the table list that is coming below.
But after this im not able to get the list of <td> using QuerySelectorAll() as there is no reliable identifier. Is there anyway to use xpaths to get the list ?
Thanks,
Arun
I am trying to retrieve all the links from site The Finder - Individual County Boundary Data
After going into URL, I want to click each alphabet
When clicking 'A' , I want to get the table list that is coming below.
VBA Code:
I am trying something like
Dim browser As InternetExplorer
Dim page As HTMLDocument
Dim htmlDoc As HTMLDocument
Dim quotes As Object
Dim authors As Object
Set browser = New InternetExplorer
browser.Visible = True
browser.Navigate ("https://thefinder.tax.ohio.gov/StreamlineSalesTaxWeb/Download/IndividualSchoolDistricts.aspx")
Do While browser.Busy: Loop
Set page = browser.Document
Set quotes = page.getElementById("Alphabet1_A")
quotes.Click
Thanks,
Arun