How to extract data from multiple tables in a web page

How to extract data from multiple tables in a web page using VBA. Earlier we learnt how to extract data from a single table automatically using VBA.

[ANUPSEXCEL]

You are great. Awesome work. Thanks a lot.

[MarkGomesdotin]

Thank You Dinesh this was informative !

[nikamabhijeet]

Hello Sir,
Is there any way to Pull specific cells from Google sheet to excel Sheet using VBA?
Thanks in advance.

[sathishkumar-rwgq]

Hi sir,

Could you please tell me how to get table 3 only..

Thanks,
Sathish kumar

[shaikhzahid]

hello sir,

please arrange your all videos in a playlist which will help learners to get their required videos it's getting difficult to find our relative topic videos.


thanks and regards
zahid shaikh

[Lamar_al-harhi]

hay sir .
how to prevent transferring excel sheet between many computers !!

[Kaviles]

When I use the code is giving on the (elemCollection.Length - 1) in the For a Compile error expected : ). Do you have a suggestion?

[daviddoughtie]

Hello I been watching your videos and i'm trying to data scrape a site for data this site has a table that has a button that is a hyper link with an "A" tagname and a href I want to create a loop with grabbing the data and going to the next page in the table and to continue that till there no more next page while pasting the data to my work sheet any help will do thank

[jmarrero]

The For statement "For t = 0 to (elementcollection.length -1)"; why is it -1?

[nagaharik]

Hello Sir,

Thank you for the code. But when i try to take the count of the tables in the webpage, using elemCollection.Length, the count is returned as zero whereas when i check the source code, and try with edit->find, i could see 3 <table tags.

my code is working without error..but neither i m getting the count nor fetching the data what i see...its fetching the tablecontent from the first web page..where i am actually entering my To Search content.

[saurabmithbavkar]

Sir i want to extract name mobile no and email id of people registered on a website. How can we do it.

[hansenxing]

Hello Dinesh,

First, thank you very much for the code. It is very useful. Second, I use the code then I add a
do until activecell.value=""
Call extractabledata
loop

The loop should be finished with 3344 times. However, every time it will stop after running 50 times with a
rum-time error '-2147467259(80004005)'
automation error
unspecified error

if I restart the computer, it will allow me to do another 50 times and then have the same error. Do you know the reason behind?

Hansen