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

Excel VBA Web Automation: Intro To Web Elements

Current Status

Not Enrolled

Price

$49.00

Get Started

Click below to log in or select lectures

Course Content

Introduction - Getting Started & Setup
Introduction and Course Download Files
Getting & Installing Selenium
Installation Troubleshooting (skip if you don't need this!)
Selenium Basics
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
Set Attributes With JavaScript Easily!
Advanced Find With 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
Selenium VBA Code Snippets - Chapter 1-3
Working With Multiple Elements At Once
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
Exercise 04a - Answer
Element Properties, Methods and Useful Information
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
Return Text Based on Regular Expression (RegEx)
Automatically Download File to Custom Folders with SetPreference()
Built In Comparison Operators
Assert vs Verify
Equals Comparison Operator
Not Equals
Contains
Custom Error Messages
Matches & NotMatches
Fail, False and True
Selenium VBA Code Snippets - Chapter 4-6
Mouse and Keyboard Actions
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
Hover MenuItem and Click On Submenu Item
Clear Out Text Entry Element

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