Excel VBA Introduction Part 47.2 - Scraping Website Tables and Clicking Links

By Andrew Gould

[pradeeprawatvlogs]

Wow actually i was looking for this topic I don’t know how to thank you.
You are my coach, mentor, guide and inspiration thank you so much sir 🙏🙏🙏🙏🇮🇳

[ramakantjoshi]

Wow!.... Sir... You are MASTER.. You have great skill of TEACHING. Will pray to GOD for your health & prosperity🙏👏🙌

[noisearchitect]

Your tutorials are the best that I have seen. Thank you for taking your time to teach us.

[charliesk]

Absolute Gold Boss! Love your videos so much I think I am addicted. Cheers!

[michaelmcnerney]

Thank you for this excellent and patient discourse on this hard to find (for me) topic

[eldarmammadov]

It gives me error on this line telling object variable is not Set "Set HTMLTables =
". I changed it to "Set HTMLTables =
Now it works, why it was so?

[edsonmatheus]

Hi Andrew, big thanks for the nice work. I tried to do this same example with XLM method but i get this error:
"Run-time error '438": Object doesn't support this property or method. The error occured in the line:
Set TableRows = & "-general-header")
Do you have any ideia what causes this?

[SujoyDebnath]

You are really a great man....Thank u for teaching us...

[KyleRichter]

Thank you so much, would you mind grouping these together as a playlist on YouTube channel’s Playlist menu like you do for your other videos? Many thanks again!

[edwinmiranda]

Very helpful and well organized video!

[linavargas]

Hola
Como puedo hacer para hacer Click en una fila de una tabla de un sitio web, en la que al pasar el puntero del mouse sobre ella, se resalta esta fila. Tengo un proyecto de automatizacion VBA en curso pero no puedo hacer esto y me siento frustrada. He intentado con el getelementsbyclass y relaciono el nombre "class" que le corresponde para luego hacer clic pero no funiona. Creo que esa tabla usa javascript.
Puedes orientarme?

[abhisheksaraswat]

Hi, Andrew, Please upload more videos on web scraping and Advanced function of VBA

[dominikba]

Hi Andrew, thanks for the video :)
I have a note that has nothing to do with the good content. Maybe you already noticed it yourself, but in the video with the number 47.1 your voice sounds a lot clearer.

[Jrohit]

Really like the videos. But have a question. Is there a command to set element value or to set a value attribute from Excel sheet?

[salmantradinglive]

Very Useful Information. But can you help me with the dropdown options

[bobnathon]

Hello Andrew Sir, how are you.

Sir when is your Birthday, pls tell.
We will feel very happy to celebrate our world's best Teacher.

[thehell]

Thank you Andrew for this great video, please Upload more video on Web scrapping with combo box click

[dereklauder]

Great video, wondering if there's a way to close ie after the code has exeuted?

[ravisuryawanshi]

Hi sir,
Can you please make entire series on this, i really need more knowledge on this as website changes are different...

[nuhzakir]

Thank you for the video and sharing your knowledge.