Need help selecting only the first ROW in a Table, Scraped from Web by MSXML2.HTML method!

objTable(0).Rows(0).Cells(0).innerText ' first table only.
Try this one as well

Please Login or Register  to view this content.

It is because you are looping through the entire table. You got the whole table rows. You need to restrict the loop in to few rows. How many tables are on the page?
What result did you get when you try objTable(0).Rows(0).Cells(0).innerText ?
You can use a direct tag name with out loop, though you have to manually count the columns
html.getElementsByTagName("td")(8).innerText

From what i can see the page contain only two, Parent Table and Children Table (the one i'm after)
I'm getting an error when i try objTable(0).Rows(0).Cells(0).innerText. maybe i did't know how to use it:D

Since I can not read or see from a picture, we have to do a trial and error. Row 0 might not exist. From picture, there are 2 tables. The one you are looking is table 2, so the code should 1( Table starts from 0).
You could include few of the rows to see which value is picked.

Myvalue1=objTable(1).Rows(0).Cells(0).innerText

Myvalue2=objTable(1).Rows(1).Cells(0).innerText

Myvalue3=objTable(1).Rows(1).Cells(1).innerText

I manage to make it work. It's still slower that i wanted
Set objTable = html.getElementsByTagName("table")
ThisWorkbook.Sheets("LogClickPhone").Range("A2") = objTable(1).Rows(1).Cells(0).innerText
ThisWorkbook.Sheets("LogClickPhone").Range("B2") = objTable(1).Rows(1).Cells(1).innerText
ThisWorkbook.Sheets("LogClickPhone").Range("C2") = objTable(1).Rows(1).Cells(2).innerText
ThisWorkbook.Sheets("LogClickPhone").Range("D2") = objTable(1).Rows(1).Cells(3).innerText
ThisWorkbook.Sheets("LogClickPhone").Range("E2") = objTable(1).Rows(1).Cells(4).innerText

Cells are injected in excel one by one not all at once. The second Cell still contains that href innerText that i don't want.
Now how can i automate it to pull data automatically every time the Row from the web table is updating and add it to the top row in excel (on top of the older row's)

Thank you very much AB33 for all you'r help, as you maybe notice, I'm a total noob at coding :D Tx

What do you mean by "Slower". The code is not looping. It is only copying 5 rows. How is that slow? Are you still using a loop?
The second Cell still contains that href innerText that i don't want.
What is the value you are getting?

It's not looping but i'm using "Set objTable = html.getElementsByTagName("table")" this is loading the hole object in "objTable". That object contains the hole content of the page(30500 Row's +).
After that i'm searching for the row i need.
So to keep it simple. How can i get the exact element's, or to be quicker the exact row i need not the hole "Parent table"

Regarding the text i don't want, pleas see below source code (the innerText i'm getting in in black font)
Untitled2.jpg
Sorry that i'm using pictures to post Source Code but i don't know how to copy text from ""Inspect element"

Originally Posted by Sean Thomas

this is never going to be lightening quick as you are first of all going to a web page, then loading your username and password, then waiting for the page to reload

how long is it taking? 3- 5 seconds?

With application.screenupdating = on off, it's taking 38.5 Seconds
Without application.screenupdating = on off, it's taking 38.7 Seconds
I'm 100% application.screenupdating is not doing anything.
As for sending user and pass then waiting for page to load, by using F8 i can determin it's taking 13.4 Seconds
So the biggest delays come from parsing the xml.responsText to html.body.innerHTML and load the hole object and then search for the row....

Set objTable = html.getElementsByTagName("table")
You are not loading anything but assigning the table object to another object.
This can not affect the speed.

So i'm stuck with this, i guess for now it will do.
Now a more excel vba problem, but related with this.
How to automate this so it's firing every 60 Seconds or so and populate the New Row in the second Row in excel A2,B2,C2,D2,E2. The Older Rows need to "step down" in excel table (A3,B3, etc) to make place for New Rows