Excel VBA Introduction Part 57.1 - Getting Started with Selenium Basic and Google Chrome

By Andrew Gould

Chapters
00:00 Topic List
00:48 What is Selenium?
02:36 Downloading Selenium Basic
02:58 Installing Selenium for VBA
04:27 Downloading the Chrome Driver
05:56 Copying the Chrome Driver to the Selenium Folder
07:18 Referencing Selenium in a VBA Project
08:22 Viewing Selenium in the Object Browser
09:36 Opening Google Chrome in VBA
11:41 Navigating to a Web Page

This video shows you how to install the Selenium Basic library for VBA so that you can control a variety of web browsers using VBA. You'll learn how to install the Selenium library, how to download drivers for Google Chrome and other browsers, how to reference Selenium in a VBA project and how to write basic code to open Google Chrome and browse to a web page.

[dom]

Excellent starting point. Andrew, your pace and clarity are spot on.

[tarekyeh]

Thank you, I've been watching your videos for years now, I really appreciate your efforts and dedication to VBA ...if you ever deiced to visit Egypt, you got your self a free tour guide, Thanks again ❤

[blakepeterson]

FYI - I was able to overcome the Chromedriver version error by saving the downloaded version, per the error message, to Basic\Chromedriver.exe. I tried various other solutions to no avail.
Thanks for a great video! I'm overdue updating my Internet Explorer web scrapers. This is a big help.

[enrikekasijas]

I missed you ! Amazing tutorials! Thanks to your vids I really improved my vba skills which I didn't have before! You are the best tutor there is and will be. I only regret I didn't find you earlier!

[CasparusBadenhorst]

Thank you for this and all the other high quality VBA tutorials.

[lequimrp]

Excellent introduction to scraping with vba. I'm used to program in vba, but I've never used scraping. Nice explanations. Thanks a lot.

[tallcypress]

Saving my life. I've been using AutoIt and VBA but AutoIt is more built around IE. Excited to find this and finally start tackling chrome scraping. Thanks for this.

[FastingDude]

This is amazing, thank you very much! Excel is highly used in corporate that running it in workbooks save so much time in automating stuff. Thanks a million again! You’re the best, you’re the last boss in legendary mode that can’t be defeated.

[FlyHigh]

Just realised you've released a new bunch of tutorials. Quite amazing how quick you've been replying to our doubts and help find solutions. Thank you, really.

[setukansara]

Another great video Andrew.
Can’t wait to see 57.2.
Learned a lot from you and still enjoy learning.
Thank you.

[johnhunter]

Andrew, you are a legend with these videos/tutorials. I have been working my way through your videos and no matter how many times I watch the same video again and again I still learn more stuff.
I have been looking for a simple explanation for a while about controlling web browers that are not ie and just realised that you only just released this. Fully agree with Enrike's comment. Big thumps up mate.

[abdullahquhtani]

Where were you MAN?! 😡 We really missed your amazing videos.

[rororara]

Welcome back!
We all miss your unique and simple way

[dukestt]

Welcome back, great to see you again.

[nwengert]

Andrew, thank you so much for this series!
PS, you should be the voice for meditation soundtracks.

[KLiCuk]

Great stuff - looking forward to the rest of the vids in the playlist 👍

[AmitSharma-pozb]

Thanks a ton Andrew for another great share from your end...keep rocking always..pls dont let us miss u..😉

[KhalilYasser]

Welcome back. Thanks a lot for this series.

[scotolivera]

God bless you and thank you for your efforts

[vh]

One of the youtubers that I will click 👍 before watching the video