Have Questions? 
help@excelvbaisfun.com
Excel Ninja Pro
All Access

Excel VBA Web Automation: Advanced Browser Control & WebScraping

Current Status

Not Enrolled

Price

$49.00

Get Started

Click below to log in or select lectures

Course Content

Timeouts and Waits
Intro to Advanced Brower Control and Course Files
TimeOuts and Wait DEFAULTS
Basic Wait Command
Exercise 08a - Question
Exercise 08a - Answer
Finding Elements With a Custom TimeOut Duration
Wait Until Element is Displayed
Wait For Specific Text or a Specific Attribute to Appear!
Wait For CSS Special Value to Appear or Change
Wait for Text To Appear or Change
WaitNotElement and By.Any
WaitEnabled or Wait Until Element is Displayed
Wait For Selection With Checkboxes and OptionButtons
Selenium VBA Code Snippets - Chapter 7-8
Browser Window Control, Navigation and Focus
SetCredentials Troubleshooting Tips and Authorization Dialog Popups
Custom Function Testing Whether Dialog Popup Is Present
Setting A Custom Profile For WebDriver Session
How To Add A Chrome Extension To ChromeDriver Sessions
Restoring a Web Session Using Cookies (Saved in Worksheet)
Custom Function To Determine If Expiry Date Is Expired
Using a Portable Version of Chrome - GoogleChromePortable
AddArguments Link and Examples
Grab Html Page Source and Text From Parent Elements
Exercise 09a - Question
Exercise 09a - Answer
Keep a Permanent WebDriver that Doesn't Close On Its Own
Frames and Frame Nagivation
BONUS - Frame Finder Custom Function
BONUS - Switch To Nested Frame Custom Function
Window, Tab Manipulation by Title, Index, Previous and Next
Accessing Window By Name, Handle
Close All Tabs Except Main Tab
Window Sizing and Position
Selenium VBA Code Snippets - Chapter 9
Image and Clipboard Manipulation
Save a Screenshot of Your Browser, Dispose Image in System Memory
Save Web Element as Image
Save Entire Desktop Screen as Image
Copy Image Directly to Excel OR To Clipboard
Image Dimensions and Resizing
Compare Two Images with CompareTo and DiffCount
Put Web Image Into Worksheet ActiveX Image Control
Load Image Into Userform Image
Working With Tables
Manipulating TableElement Data as Array onto Worksheet
Loop Through Elements in Specific Column Only
Loop Through Multiple Specific Columns Using OR Operator
Put Specific Columns into List Object, To Excel Easily
Exercise 11a - Question
Exercise 11a - Answer
Selecting Options from Dropdowns and Listboxes
Declare SelectElement, Read and Write Dropdown Control
Select Using the Index Number
Select Using Internal Option Value
All About The Options Collection
Controlling Multiple Select ListBoxes and Gathering Selected Options
Using The Mouse To Select Multiple Options
Deselecting All Options or Specific Options
Selenium VBA Code Snippets - Chapter 10-12
Exercise 12a - Question
Exercise 12a - Answer
BONUS - Extra Troubleshooting Tips
Error Loading Extension Help
Error Loading Extension Help - Source Code

Excel VBA Is Fun

We believe Excel is one of the most versatile programs out there - and learning to program and automate it makes you very valuable!

You can prevent wasted time and errors, speed up tasks and become indispensable to your organization. 

See how our trainees have gotten raises, promotions and bonuses using their Excel Automation skills while building real problem-solving programs in Excel!
LEARN MORE
Copyright © 2025 ExcelVbaIsFun
X

Forgot Password?

Join Us

linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram