Complete Web Automation With Excel Vba

Fill Out Web Forms Dynamically, Navigate Web Pages Intuitively, And Extract & Manipulate Data To Increase Efficiency!

Last updated 2022-01-10 | 4.8

- Locate elements using Basic Strategies (ID
- Name
- Tag
- Class)
- Search for Links using Link Text or Partial Link Text!
- Master XPath Location strategies and functions for hard to pinpoint elements

What you'll learn

Locate elements using Basic Strategies (ID

Name

Tag

Class)

Search for Links using Link Text or Partial Link Text!

Master XPath Location strategies and functions for hard to pinpoint elements

Deal with Popups

Alerts

Notifications and Frames like a boss!

Utilize Attributes to unearth embedded content

Pinpoint elements using Relative or Absolute Xpath

Learn the secret benefits of CSS Selectors

View and Parse inner html document information

Use free extensions and tools to locate best Xpath or CSS Selectors

Capture Groups of Elements into Arrays

Lists or Straight to Excel!

Sort and Remove Duplicates from a List Object

Locate all sub elements of a div

table

or larger parent element

Determine if element Exists

is Enabled

Hidden

Selected

Checked or Unchecked

Evaluate hidden CSS Properties

such as 'width'

'background color'

etc

Understand Regular Expression (RegEx) patterns and using pattern matching

Get element Position and Size and Scroll element into View when necessary

Create custom error messages to evaluate comparison (Equality

Contains

NotEquals

Matches

Fail…)

Discern the difference between Assert and Verify operators

Programmatically hover

click

click and hold

release

right click and double click with the Mouse

Send Keyboard combination presses as well as regular word character presses to the browser

Drag and Drop elements or text to another area or drag files for Upload programmatically

Control Timeouts and Wait default settings for PageLoad

Element searches and Server timeouts

Delay execution until controls are Visible

Enabled

Text is displayed or changed

Checkboxes/Optionbuttons are selected

Wait for CSS special values change or meet conditions

Test for the presence of Dialog popups

Navigate with Basic Web Controls - Back

Forward

Reload

Close Driver

Close Single page

Urls

Save and Load specific user profile for WebDriver execution

Enter and Exit specific embedded Frame controls and their html content

Open

Access and toggle multiple tabs/windows and Select by Index

Title or Window Handle

Resize and Position Browser window to user specifications

Save Screenshot of Browser

Web Element(s)

or entire Desktop to Excel or to a file

Copy Image directly to Excel OR to Clipboard

Change image dimensions and resize

Compare multiple image files

generating an image of differences

Cast image elements into ActiveX Image Control on worksheet or Userform!

Convert Web-Table into TableElement Object and manipulate as array or directly to Excel

Extract specific Web-Table column(s) instead of whole table!

Dynamically select one or more Dropdown or Listbox options programmatically or using mouse clicks

Deselect all options or explore 'Options' collection and properties

* Requirements

* You should already have Microsoft Excel (version 2003
* 2007
* 2010
* 2013 or 2016). Obviously the newer the better
* but VBA works the same in all versions. It's just that newer versions have more options
* thus more VBA Commands to control those options.
* Very very basic Excel skills needed for this course. IF you know Basic to Intermediate Excel VBA
* you can surely find more ways to utilize this info
* but is not required as I explain everything in detail.

Description

Locate elements using Basic Strategies (ID, Name, Tag, Class)
Search for Links using Link Text or Partial Link Text!
Master XPath Location strategies and functions for hard to pinpoint elements
Deal with Popups, Alerts, Notifications and Frames like a boss!
Utilize Attributes to unearth embedded content
Pinpoint elements using Relative or Absolute Xpath
Learn the secret benefits of CSS Selectors
View and Parse inner html document information
Use free extensions and tools to locate best Xpath or CSS Selectors
Capture Groups of Elements into Arrays, Lists or Straight to Excel!
Sort and Remove Duplicates from a List Object
Locate all sub elements of a div, table, or larger parent element
Determine if element Exists, is Enabled, Hidden, Selected, Checked or Unchecked
Evaluate hidden CSS Properties, such as 'width', 'background color', etc
Understand Regular Expression (RegEx) patterns and using pattern matching
Get element Position and Size and Scroll element into View when necessary
Create custom error messages to evaluate comparison (Equality, Contains, NotEquals, Matches, Fail…)
Discern the difference between Assert and Verify operators
Programmatically hover, click, click and hold, release, right click and double click with the Mouse
Send Keyboard combination presses as well as regular word character presses to the browser
Drag and Drop elements or text to another area or drag files for Upload programmatically
Control Timeouts and Wait default settings for PageLoad, Element searches and Server timeouts
Delay execution until controls are Visible, Enabled, Text is displayed or changed, Checkboxes/Optionbuttons are selected
Wait for CSS special values change or meet conditions
Log In using set credentials to site
Test for the presence of Dialog popups
Navigate with Basic Web Controls - Back, Forward, Reload, Close Driver, Close Single page, Urls
Save and Load specific user profile for WebDriver execution
Enter and Exit specific embedded Frame controls and their html content
Open, Access and toggle multiple tabs/windows and Select by Index, Title or Window Handle
Resize and Position Browser window to user specifications
Save Screenshot of Browser, Web Element(s), or entire Desktop to Excel or to a file
Copy Image directly to Excel OR to Clipboard
Change image dimensions and resize
Compare multiple image files, generating an image of differences
Cast image elements into ActiveX Image Control on worksheet or Userform!
Convert Web-Table into TableElement Object and manipulate as array or directly to Excel
Extract specific Web-Table column(s) instead of whole table!
Dynamically select one or more Dropdown or Listbox options programmatically or using mouse clicks
Deselect all options or explore 'Options' collection and properties