VBA Excel getElementsByClassName without child results

[yamik85]

Hi

I have problem with "getElementsByClassName". I am trying to get only the FIRST one class without any child.
I have: Set elements = html.getElementsByClassName("typstable")
But in the results, I got also "typstable tabMundial" what is no needed. How can I take only the first one result or exactly the name of the class without any child?

I don't know exactly quantity of records for the tables what I want. Tables have random records numbers. I can check the data in the excel if the entries is correct and delete the wrong ones but I hope there is a better solution like "html.getElementsByClassName("typstable")[1] or html.getElementsByClassName("typstable")(1)" I don't know. But this solutions also makes the problem if class with child will be first so the best solution will be take only the class tag without any childes.

 

[Domenic]

getElementsByClassName returns a collection of elements, and the index for the collection starts at 0. So to return the first element in the collection...

html.getElementsByClassName("typstable")[COLOR=#ff0000](0)[/COLOR]

So if you were to use early binding, you would do this way...

Dim element As MSHTML.IHTMLElement

Set element = HTML.getElementsByClassName("typstable")(0)

Hope this helps!

 

[yamik85]

Thx for the answer. I was trying before:

Set element = HTML.getElementsByClassName("typstable")(0)

And it always gave me an error so I thought it's impossible to do like that. Now I did step by step again and I found my silly fault
I got collection..

Dim elements As IHTMLElementCollection
Set elements = html.getElementsByClassName("typstable")(0)

Now I did like you wrote:

Dim element2 As IHTMLElement
Set element2 = html.getElementsByClassName("typstable")(0)

And it works like I want now. Thx for the help.