Hey All,
I'm trying to extract text from an intranet webpage of my company and put it into excel. Below the line I use for trying to get it:
The code marked green works well. VBA finds the h3 number 34 in the web source and .innerText gets the correct h3 value. Problem is, I actually want something that is further down from that h3. I thought I would just add another getElement(s)By method. I first used:
- Run-time error '5002': Application-defined or object-defined error.
Then:
- Run-time error '91': Object variable or With block variable not set.
I don't know what else I can do to point excel the location of the text I need copied to a cell... Below I also paste an excerpt of the webpage source code. I only changed some data which is company confidential, all divs, classes etc. are unchanged:
Bookmarks