Excel VBA Web Automation: Advanced Browser Control & WebScraping
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
Alerts - Using Multi Options (OK and Cancel, OK Only & Text) with An Alert
SetCredentials Troubleshooting Tips and Authorization Dialog Popups
Custom Function Testing Whether Dialog Popup Is Present
Basic Navigation - Back, Forward, Reload, Close Driver, Close Single page, Url
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
Add Special Arguments to Customize Browser Options - Incognito or Hidden Window
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
Several Ways To Open a New Tab In Current Session
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
Converting a Web Table to TableElement Object and Inserting into Worksheet
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
Previous Lesson
Next Lesson
Several Ways To Open a New Tab In Current Session
Excel VBA Web Automation: Advanced Browser Control & WebScraping
Several Ways To Open a New Tab In Current Session
Previous Lesson
Back to Course
Next Lesson
close
bars
angle-double-down
X
Username
Password
Remember me
Forgot Password?
Join Us
Login
Accessing this course requires a login. Please enter your credentials below!
Username or Email Address
Password
Remember Me
Lost Your Password?
Register
Don't have an account? Register one!
Register an Account
linkedin
facebook
pinterest
youtube
rss
twitter
instagram
facebook-blank
rss-blank
linkedin-blank
pinterest
youtube
twitter
instagram