Two questions:ĭownloading the HTML of one line so I can manually parse it I now want to automate this hence my interest in your post. In the past, I have copied the HTML into a spreadsheet and parsed the html lines there to get at what I want. I can get the innertext but am struggling to get some additional data like an href giving the URL. Many thanks for a great post which I've now successfully modified to scrape 2 sites I need data from. Set HTMLButton2 = HTMLDoc.elementFromPoint(314, 490)Īrray_objects(index).date = HTMLButton1.innerText 'line2Īrray_objects(index).protocol = HTMLButton2.innerText Set HTMLButton1 = HTMLDoc.elementFromPoint(338, 462) The HTMLButton1 and HTMLButton2 when tried in debug.print show nothingĭim IE As New SHDocVw.InternetExplorerMedium Basically it is not reading the html document on a different system. BUT when I try to use the same code/module to extract data from the html file from my Friend's system it shows me an "error 91: object variable or with block not set" at line 2 and sometime even at line 1. I have been trying to follow your videos and extract data from an HTML file and I was able to do so on my system. Start by getting a handle on the HTML document, as above: Here's the entire subroutine, in parts, with comments for the HTML bits. Know this), but we're going to do it the slightly harder way, by finding tagsĪnd then looping over their contents. You could now parse the HTML using the Document Object Model (for those who Loads up an HTML document, and shows its text.
Navigates to the StackOverflow home page.Creates a new copy of Internet Explorer to run invisibly in.'open Internet Explorer in memory, and go to websiteĭo While ie.readyState READYSTATE_COMPLETEĪpplication.StatusBar = "Trying to go to StackOverflow. 'to refer to the running copy of Internet Explorer
0 kommentar(er)
