Excel VBA Web Automation: Intro To Web Elements

Introduction - Getting Started & Setup
Introduction and Course Download Files
Getting & Installing Selenium
Installation Troubleshooting (skip if you don't need this!)
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
Set Attributes With JavaScript Easily!
Advanced Find With XPath
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
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
Regular Expression Patterns!
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
DragAndDrop - Dragging File for Upload Programmatically
Hover MenuItem and Click On Submenu Item
Clear Out Text Entry Element
Previous Lesson
Next Lesson

New Change Attribute Custom Function and Huge Demo

Excel VBA Web Automation: Intro To Web Elements New Change Attribute Custom Function and Huge Demo

Welcome Visitor! Please enjoy this FREE Preview below and when you're ready, click the Next Preview button below or look for lectures with the green 'Unlocked' symbol to browse.


Next Preview

Previous Lesson
Back to Course
Next Lesson
Post a comment

Leave a Comment

X

Forgot Password?

Join Us

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