I’m trying to retrieve a list of attendees to an event on a webpage. If I use a browser, to the webpage, right click, and choose View Page Source I can see the names of the attendees.
I need to do this with VBA. I have tried 3 different properties (objIE.Document.body.innerText, objIE.Document.body.innerHTML, objIE.Document.body.textContent) of the IE object and none return the attendee names. Something is going on behind the scenes. How do I fix this?
Public Sub OpenWebsiteAndRetrieveData()
Dim objIE As Object
Dim strURL As String
Dim strPageContent As String
Dim strinnerText As String
Dim strinnerHTML As String
Dim strTextContent As String

Hi I am trying use VBA to look property tax records off of. I’d like to return the owner of a property in column B, given the address is column A.