VBA data grab not working

[Pak Mariman]

I am trying to extract the text from a translated patent using below code. The code should cycle through the divs of the web page and extract the translated text blocks whenever it encounters them.

What did I do wrong?

Please Login or Register  to view this content.

[omahaNative_1023]

Well it depends on what the error message is. Did you get one or what was the result? If not, you have to make sure that all the properties are correct. Furthermore, divs almost along with almost everything else in the Dom have a property called length. You have to loop through that. You really should look up the property called get elements by tag name that you are using. are you sure that that returns a collection because that's what you're trying to look at with your code?it's impossible to give you an answer unless you tell what's wrong. You didn't say anything you just said something's wrong.

[Pak Mariman]

Well it depends on what the error message is. Did you get one or what was the result? If not, you have to make sure that all the properties are correct. Furthermore, divs almost along with almost everything else in the Dom have a property called length. You have to loop through that. You really should look up the property called get elements by tag name that you are using. are you sure that that returns a collection because that's what you're trying to look at with your code?it's impossible to give you an answer unless you tell what's wrong. You didn't say anything you just said something's wrong.

The code runs, gives no error message, but returns 0 to cell A1.

[Marc L]

According to the url explain at least what is the expected result as after all this is very not a mind readers forum …

[Pak Mariman]

According to the url explain at least what is the expected result as after all this is very not a mind readers forum …

The Original description is here.

I would want my code to grab the translation here.

[omahaNative_1023]

Well first of all, the variable you are using to accept or try and accept all of the information coming from all of the div tags and the collection of them, does not make sense doesn't? Because you are getting response text by using XML library from Microsoft but you're not doing anything with that. But to point again, I think the reason you get zero is because obviously nothing is being thrown into variable. That is very common when it comes from a page architected by the Dom. 0 literally means empty set I think when coming from web applications and elements like that in html. It might mean or might indicate a length but not sure about that one. Don't think so. But anyway, I think real issue here is that you are getting zero because, even though you are using valid property and getting collection returned by specifying tag name, a div has many things inside of it, including inner text and inner HTML. If you just ask for a div tag, I don't think you are supposed to get anything. First off, look at those two attributes and try and run code and get information from those. If you can then I may be correct in terms of that's what you need to get info from instead of just top level tag of div.

[Marc L]

I would want my code to grab the translation here.

Which webpage elements, from where until … ?

[Pak Mariman]

Which webpage elements, from where until … ?

I would want to grab all text from

<div id="DESCRIPTIONmySpanp1s1Text" class="text">Method of grinding the powder using a medium with zirconium orthosilicate </div>

until and including

<div id="DESCRIPTIONmySpanp96s0Text" class="text">Particle sizes were determined using a Microtrac® particle size analyzer as described above. </div>

[Marc L]

What did I do wrong?

So much to say !

You did not choose the obvious elements to search for according to any webbrowser inspector tool …

But far above all, you did not see the initial webpage code you get via the property 'responseText'
does very not contain any element you wanna grab !
As once the initial webpage is loaded some java scripts are executed in order to fill the webpage
like you can check in the initial webpage code or via the inpector tool, whatever …

So if you really want to import the text under VBA you can do it via piloting Internet Explorer.

[Pak Mariman]

So if you really want to import the text under VBA you can do it via piloting Internet Explorer.

... how? Is there some example code or relevant literature on how to do this?

[Marc L]

Yes, some examples on forums.
Another way than piloting IE may be via Power Query / Get and Transform depending on the Excel version …