Introduction - Getting Started & Setup

Selenium Basics

Opening a Web Page

Web Elements 101 - Type in Textbox and Click Search Button (ID,Name Selectors)

Overview - Popular Tags and Attributes

Strategies - "Tag"

Awful-Valentine Site Expired, But We Downloaded It!

Strategies - "Class"

Exercise 02a - Question

Exercise 02a - Answer

Strategies - "LinkText"

Looking At Attributes - More Than Just TEXT!

Strategies - "PartialLinkText"

Strategies - "CSS Selectors" Intro

How to Install a Chrome Extension

CSS Selector Helper for Chrome

CSS Selector Tool - ChroPath and Technical Demonstration

BONUS - ChroPath Serious Upgrades - Now Called SelectorsHub

BONUS - Set Value versus SendKeys To TextBox

Create or Change Any Attribute Using Javascript

New Change Attribute Custom Function and Huge Demo

Advanced Find With XPath

Set Attributes With JavaScript Easily!

Intro to XPath

XPath Helper Tool

ChroPath with XPath for Relative and Absolute Reference Types

XPath Function - Contains()

XPath Function - Text()

XPath Function - AND, OR

XPath Function - Starts-With()

XPath - Axes

XPath Function - Last()

Selecting a Specific Index for XPath Query!

Exercise 03a - Question

Exercise 03a - Answer

More XPath Resources

Working With Multiple Elements At Once

Selenium VBA Code Snippets - Chapter 1-3

Working With a Group Of Elements (FindElements)

Looping Through a Set of Elements, Declaration Tips

Grab the Text For Each Element Into A List

Grabbing All Attribute Values into a List

Add, Remove or Change an Element from a List

Get Count of List Items or Web Elements

Remove Duplicates Elements from List

Sorting Your List

Importing Items to Excel Directly!

Looping Through a List of Attributes for a Set of Elements

Exercise 04a - Question

Element Properties, Methods and Useful Information

Exercise 04a - Answer

Finding Elements within an Element

Find The Active Element

Understanding the 'By' Object

Does The Element Exist Using 'By' Object

Does Element Exist Using WebElement Object (2 Ways!)

Value, Tagname, Text & Css Properties

Specialty Text Variations

Discover Whether Element is Displayed, Enabled, Present, Selected...

Pagination - Clicking Next Until You Reach the Last Page

Element Position and Size

Scrolling Element Into View

Regular Expression Patterns!

Return Text Based on Regular Expression (RegEx)

Built In Comparison Operators

Automatically Download File to Custom Folders with SetPreference()

Assert vs Verify

Equals Comparison Operator

Not Equals

Contains

Custom Error Messages

Matches & NotMatches

Fail, False and True

Mouse and Keyboard Actions

Selenium VBA Code Snippets - Chapter 4-6

Click, Click and Hold, Release, Right Click & Double Click

SendKeys and Keys Modifiers

KeyDown, KeyUp

Exercise 07a - Question

Exercise 07a - Answer

DragAndDrop - Swapping Elements, Better with JavaScript

DragAndDrop - Element Disappears Once Dropped

DragAndDrop - Dragging Text Programmatically

DragAndDrop - Dragging File for Upload Programmatically

Hover MenuItem and Click On Submenu Item

Timeouts and Waits

Clear Out Text Entry Element

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

Browser Window Control, Navigation and Focus

Selenium VBA Code Snippets - Chapter 7-8

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 Object Variable)

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

Image and Clipboard Manipulation

Selenium VBA Code Snippets - Chapter 9

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

Working With Tables

Load Image Into Userform Image

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

Selecting Options from Dropdowns and Listboxes

Exercise 11a - Answer

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

BONUS - Extra Troubleshooting Tips

Exercise 12a - Answer

Error Loading Extension Help

Error Loading Extension Help - Source Code

Previous Lesson

Next Lesson

Several Ways To Open a New Tab In Current Session

Complete Web Automation with Excel VBA Several Ways To Open a New Tab In Current Session

Previous Lesson

Back to Course

Next Lesson