getElementsByTagName Issue

**Andreaxs** · Sep 24th, 2017, 04:59 AM

Hello!
I' m having issue finding elements in htlm code.

Here is my HTML code that i create to understand and test the getElementsByTagName method in VBA.

HTML Code:

<html>
<body>

<td> Id number </td>

<table>
	<tr>
		<td> Id number </td>
		<td> Last name </td>
		<td> First name </td>
		<td> Number </td>
	</tr>
	<tr>
		<td> Id number </td>
		<td> Last name </td>
		<td> First name </td>
		<td> Number </td>
	</tr>
</table>
</body>
</html>

Using this vba code:

Code:

conta = 0
Set elements = ie.Document.getElementsByTagName("body")
For Each element In elements
    conta = conta + 1
Next element
MsgBox ("") & conta

I found 1 body element.

But if i try this one:

Code:

conta = 0
Set elements = ie.Document.getElementsByTagName("tr")
For Each element In elements
    conta = conta + 1
Next element
MsgBox ("") & conta

The result is 0. Tried also to find the td elements and the result is 0.
Can't understand.
Wouldn't getElementsByTagName method give the collection of elements with the given tag present in the body?

**westconn1** · Sep 24th, 2017, 04:36 PM

I found 1 body element

in the first case, only one element is returned in the collection so the result is correct, to count all the elements within the body you need like

Code:

For Each element In elements(0).all

or in the case where multiple elements could be returned, you would need a double loop

Code:

For Each element In elements
    for each ele in element.all

returned 14

the second example returned 2 for me which was also correct

Thread: getElementsByTagName Issue

Thread Tools

Display

getElementsByTagName Issue

Re: getElementsByTagName Issue

Posting Permissions