Import Web Data to Excel using VBA Macros

It's time to learn how to use VBA and Macros to import data from a web page into Excel!

This is the advanced way to get almost any piece of data from a web page and to bring it into Excel and I take the tutorial step-by-step to explain everything that you need to do.

As well, the macro that we use is a very simple yet powerful and robust piece of code that will work in a wide variety of situations and that does not require the browser to open or be used at all.

This tutorial walks you through each line of the macro required to perform the import so that you will understand it and be able to change it for your specific purposes. As well, this covers different elements of a web page that you need to understand in order to make better web imports of data using VBA.

I hope you enjoy the tutorial and make sure to leave a comment and thumbs up ;)

[TeachExcel]

200+ Video Tutorials - 200+ Downloadable Excel Reference Files - 50+ Hours of Content

[RenLord]

This tutorial is pure gold, I tried to do something similar with the help of AI, but this video is what helped me the best, thank you.

[veggiemix]

I wasn't looking for getting stock price but the title of this video caught my eye and I watched the whole video. I like the speed of your talk: slow and clear. Students take time to learn new information and the delivery of your talk is just the right pace! Thank you!

[lucasborges]

I dont comment too often, but I had to for this one. Brilliant! Thank you for sharing

[TheAJKahn]

The most simplest macro I've found with the simplest explanation. Great video. I wish I could've found your video earlier. 5 Thumbs UP!

[evehenare]

Great tutorial thank you, tied together alot of concepts for me. I like how youve given extra explanation like synchronous execution or the grouping for an IF statement, but given basic overviews and said what to do to make it work. Thank you!

[NguyenAnh-xnpb]

Hi there, I got run-time error'91' object variable or with block variable not set at command price. Could you help me figure out what it is?

[brandonspiegel]

Thanks for the knowledge man! I will use the knowledge to get closer to my first million man!

[juergon]

Thank you for this tutorial. I arrived to this tutorial searching a way how to solve a "the inner text retrieved values does not refresh...". It seems from the video that you encountered the same problem even though you are using the since 2000 year...Best regards

[aliilhanhaliloglu]

MOMMM I have just found the best video on the internet

[SunilMathewMusic]

This is one the best tutorials I have even seen 👌💥Top Class

[dino-art]

Excelent way with which i introduced objects to my VBA learning :D

[carterbates]

Super helpful video, especially for someone like me with little VBA and html experience. I was looking for a method to pull up-to-date stock price information so this was perfect, .

[michaelkaczmarek]

Great video! I am new to VBA Macros and trying to figure out how to add to a list of product EAN numbers their price according to Google Shopping. This seems to be a great base to make such a macro. Now I only need to:
a) Make the macro adapt the url for each EAN code entered into Google Shopping search field
b) Insert the price into the corresponding cel instead of opening message boxes

[Mrshanmugham]

Excellent Excellent, What I want, working fine, Thank you very much Brother

[KnuYorker]

This clarified many doubts that I had. Thank you.
I look forward to using this technique soon.

[knives]

Hi, very new to excel
Great vid but I have a few questions
1) Can and how do you pull multiple items from a website.
2) How do you add in a step to access a website that requires you to log in first?
3) How do you automate this to pull the same date for a series of stock symbols?
Thanks,
R-

[johnharoldverzosa]

i tried editing the code the website and the element name. but i got a run time error 91. can help me?

[pragadeeshmurugesan]

Hi I got a error.msg run time error 438 objects doesn't support this property or method it indicate the line price =

[hadeelo]

amazing video and working 100% the best I found soo far but if my website have username and password what changes I need to do for the same code explained in the video