The Easiest Way to Scrape Web Data with VBA

The Easiest Way to Scrape Web Data with VBA

In this video I show you how to scrape data using a little-known method. The method is powerful because it only requires a few lines of code and doesn't require any installation or browser.


Free Excel VBA Resources

Useful VBA Shortcut Keys
========================

Debugging:
Compile the code: Alt + D + L OR Alt + D + Enter
Run the code from the current sub: F5
Step into the code line by line: F8
Add a breakpoint to pause the code: F9(or click left margin)

Windows:
View the Immediate Window: Ctrl + G
View the Watch Window: Alt + V + H
View the Properties Window: F4
Switch between Excel and the VBA Editor: Alt + F11
View the Project Explorer Window: Ctrl + R

Writing Code:
Search keyword under cursor: Ctrl + F3
Search the word last searched for: F3
Auto complete word: Ctrl + Space
Get the definition of the item under the cursor: Shift + F2
Go to the last cursor position: Ctrl + Shift + F2
Get the current region on a worksheet: Ctrl + Shift + 8(or Ctrl + *)
To move lines of code to the right(Indent): Tab
To move lines of code to the left(Outdent): Shift + Tab
Delete a Line: Ctrl + Y(note: this clears the clipboard)

[bredmond]

No kidding. I've been watching videos on VBA web scraping since yesterday and was going through YouTube literally right now looking for more getting ready for a project. Then you post this new video in the middle of that. Thank you!

[serdip]

Another AMAZING video! Thanks very much for showing how easy it can be to scrape data from web pages. The solution presented is simple and elegant and easily adapted to a wide variety of use cases. Thank you!!

[AlejandroSerranoJuan]

Really. You are the best VBA code professor I know. As you keep sharing we keep improving. Thanks for it.

[redfeathersa]

Brilliant Paul !!! Thanks !! I've been using the same for years but glad there's an accessible reference to it on YouTube now !!

[CAPNE]

Very good video and annotations. In about only 7 minutes I've learned more then in an hour of searching and reading.
Many thanks for that!

[cristiano]

The most useful thing I've seen this year... man... you rock!

[compscript]

This was great.
I have been watching videos all day and this is the first one that worked.
I look forward to watching this same video using other methods besides tables.

[jenniferbabitzke]

This video and code is going to save me countless hours on a research project. Thank you so much!!!

[hassanrozh]

Great job, thanks for sharing this helpful way.

[stevennevin]

Excellent explanation. You have made this task much less daunting. 👏.

[CanalInvestidor]

Excellent tutorial, makes it possible to explore many fronts.

[MichaelWilliams-rfjw]

I love this video! Thanks for sharing this info.

[Code_Play_com]

Very practical and helpful video with very detailed explanation!

[free]

Very helpful examples, thank you for the video!

[turkaykoc]

Thank you very much for sharing valuable information.

[HectorAgostoOne]

Ahhh. This is excellent but I got so hooked to Power Automate for web scraping as it makes it sooo easy. Still, this tutorial is A+. Going to attempt this to have further hands on knowledge on vba

[joaocustodio]

As always... well done Paul. Thanks very much.

[alexandrumoldovan]

Great video with lots of insights, which is really the norm for Paul at this point.
Query tables look really powerful, maybe you could make a video more in detail about it in the future. I'm sure many, myself included, would find that very helpful.
Thank you!

[deexcelguy]

Mind-blowing... Best Web scrapping with VBA video ❤❤❤

[vbaclasses]

Great video, thanks for sharing. Another tool in the toolkit.