By Andrew Gould
If you’d like to help fund Wise Owl’s conversion of tea and biscuits into quality training videos, you can click this link to make a donation. Thanks for watching!
Selenium documentation
Selenium Basic
Chrome Driver
.NET Framework 3.5 for Windows 10 (install this if you see Automation Error)
Links to other web drivers
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.
Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Power BI, DAX, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access and more