Excel VBA Introduction Part 46 - Querying Web Pages using Query Tables

By Andrew Gould

[maurocastagnera]

You are the best teacher I have ever met! You are simply fantastic. It is an honor for me to be able to learn from you. Thank you!

[soup]

God...I finsihed this video in one time...almost no need to rewind to understand. The other guy's video, I watch a week and haven't finished one hour video...Thank you. I like yours...not just a little better than others...

[ricemonster]

Andrew, I rarely comment on Youtube, but you are by far the best teacher anywhere. Your enthusiasm and dedication is contagious. Slightly off topic, but your generosity to put this much content online is giving me hope in humanity again

[DineshKumar-lqck]

its biggest charity to share knowledge, may god bless u

[gopighodke]

I found this site is one of the best educational source. Teaching skill are awesome ! great !

[novicetech]

This is too awesome. I jumped ahead to see where the course was headed and landed on this video. Simple awesome. When I compare this to the steps it takes to do the same thing in Python, I'm just blown away. Thanks.

[mhfs]

i consider myself quite knowledgable on Excel and VBA. If been using Excel since version 5. I genuinely learned something new.

Clear explanation. Good pace. Lovely voice.

[Dany-nshg]

You really explained very well since you explain the concept first and then the solution, this technic needs to be applied by every teacher. Keep it up

[evanexcel]

The most perfect explanation ever heard! Always to the point!!

[satejilkar]

You are best teacher i have meet online... thanks alot

[CyrusPieris]

Thanks wiseowl> I will be donating. This is an amazing course. Thank you for putting the time and the book is excellent.

[ALEXSHUNCAI]

It is outstanding! I am in the middle of learning your VBA course, I think for the students who need to learn the Excel VBA, your videos are the must to watch, your excellent teaching styles makes the course extremely educating and entertaining.

One thing I would like to ask you is: are there any VBA courses related to the importing live data from certain trading platform console to the excel and use certain modeling to determine the trading strategy, for example, if I am using IB (Interactive Broker or Etrade) to import the live data to excel, and then plot these live data minute by minute, such as moving average, RSI and so on, then use these information to determine buy or sell, any courses related to these topics?

Again, thank you so much.

[ricardosantos]

Awesome tutorial !!!

Thank you very much, Andrew.

The videos of this channel are outstanding!!!

Congrats,

Regards

[cratos]

I Was looking this for Ages! Thank you Sir very good explanation and tutorials.

[rallydv]

very helpful and quite love the accent!

[mahdjoubsofiane]

reallly fantastic, if i found every thing i need in the wise owl cources, i will not use onother source to learn my vba cources

[janezklun]

Great video as always, thank you for sharing

[vishnulalraveendrannair]

Dear Andrew, thanks for this video. You really make our lives so easier.

I'm an ardent follower of your channel and have learned a lot by just tuning into your channel.

I see that the video on automating web works wonderfully well. I have tried many websites and found it working without any hassles. However the same code isn't working when I try to implement in my office. I mean these codes don't work for internal websites of my organization. I'm getting automation error(unspecified error)/ disconnection error (the object invoked has disconnected from its clients) when I try to run the same code.

Is there a special reason or if there is any other way round?

[perfoperfo]

Great tutorial. I followed it easily and it all worked first time, which is pretty rare for YouTube videos. I have a question please. When using the sites you suggest it works great. When I try on another site it doesn't return any data. The other site clearly has tables on but looking at the source code I cant see any table tags. What's the best way to get data out of those types of web tables ? Thanks.

[TonyDiaz.]

Very, very nice!!! This helps me a lot. I want to do it with a website that has a login system.
I'll play around, see what I come up with. Thanks as always my friend...