Hi All,
I am trying to retrieve data from a website. I need to click each alphabet & retrieve the response or table rows. I am able to navigate to the page, but not able to simulate the click on the id with 'Alphabet1_A'. Can you share some directions ?
Thanks in Advance.
Regards,
Arun
I am trying to retrieve data from a website. I need to click each alphabet & retrieve the response or table rows. I am able to navigate to the page, but not able to simulate the click on the id with 'Alphabet1_A'. Can you share some directions ?
Thanks in Advance.
VBA Code:
Sub scrape_quotes1()
Dim XMLPage As New MSXML2.ServerXMLHTTP60
Dim htmlDoc As New MSHTML.HTMLDocument
Dim URL As String
' Set browser = New InternetExplorer
' browser.Visible = True
URL = "https://thefinder.tax.ohio.gov/StreamlineSalesTaxWeb/Download/IndividualSchoolDistricts.aspx"
XMLPage.Open "GET", URL, False
' XMLPage.send
XMLPage.send "Alphabet1_A"
htmlDoc.body.innerHTML = XMLPage.responseText
'Do something with the information
Cells(1, 1).Value = htmlDoc.body.innerHTML
End Sub
Regards,
Arun