Complete Web Automation with Excel VBA
4.6 (583 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
4,061 students enrolled

Complete Web Automation with Excel VBA

Fill Out Web Forms Dynamically, Navigate Web Pages Intuitively, And Extract & Manipulate Data To Increase Efficiency!
Bestseller
4.6 (583 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
4,061 students enrolled
Created by Daniel Strong
Last updated 4/2020
English
English [Auto]
Current price: $139.99 Original price: $199.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 9.5 hours on-demand video
  • 13 articles
  • 28 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
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
  • 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
Course content
Expand all 144 lectures 09:20:02
+ Introduction - Getting Started & Setup
3 lectures 09:04

Introduction to the course and Downloadable files.

*See why Selenium is a gazillion times better than traditional ways of controlling web sites.

Preview 03:07

Here's how to get set up with Selenium with Excel.

Preview 04:24

This document is to help those who have had trouble after attempting the installation. These tips will get you patched up and on your way!

Installation Troubleshooting (skip if you don't need this!)
01:33
+ Selenium Basics
19 lectures 01:41:51
Strategies - "Tag"
04:16
Awful-Valentine Site Expired, But We Downloaded It!
02:41
Strategies - "Class"
04:45
Exercise 02a - Question
00:12
Exercise 02a - Answer
04:49
Strategies - "LinkText"
01:19
Looking At Attributes - More Than Just TEXT!
03:13
Strategies - "PartialLinkText"
01:37
Strategies - "CSS Selectors" Intro
07:16
How to Install a Chrome Extension
00:57
CSS Selector Helper for Chrome
03:57
CSS Selector Tool - ChroPath and Technical Demonstration
08:39
BONUS - Create of Change Any Attribute Using Javascript
10:49
BONUS - New Change Attribute Custom Function and Huge Demo
08:30
+ Advanced Find With XPath
14 lectures 45:37
Introduction to XPath
05:04
XPath Helper Tool
04:12
ChroPath with XPath for Relative and Absolute Reference Types
05:08
XPath Function - Contains()
04:01
XPath Function - Text()
01:44
XPath Function - AND, OR
02:22
XPath Function - Starts-With()
01:00
XPath - Axes
07:21
XPath Function - Last()
02:32
Selecting a Specific Index for XPath Query!
03:49
Exercise 03a - Question
00:12
Exercise 03a - Answer
07:54
More XPath Resources
00:14
Selenium VBA Code Snippets - Chapter 1-3
00:04
+ Working With Multiple Elements At Once
13 lectures 41:45
Working With a Group Of Elements (FindElements)
04:34
Looping Through a Set of Elements, Declaration Tips
04:11
Grab the Text For Each Element Into A List
03:05
Grabbing All Attribute Values into a List
01:18
Add, Remove or Change an Element from a List
05:01
Get Count of List Items or Web Elements
01:35
Remove Duplicates Elements from List
01:01
Sorting Your List
00:56
Importing Items to Excel Directly!
01:55
Looping Through a List of Attributes for a Set of Elements
08:23
Wikipedia, get all links, then visit the 10th link after sorting
Exercise 04a - Question
00:12

Wikipedia, get all links, then visit the 10th link after sorting!

Exercise 04a - Answer
06:15
Finding Elements within an Element
03:19
+ Element Properties, Methods and Useful Information
14 lectures 01:01:57
Find the Active Element
03:15
Understanding the 'By' Object
02:33
Does The Element Exist Using 'By' Object
02:18
Does Element Exist Using WebElement Object (2 Ways!)
04:24
Value, Tagname, Text & Css Properties
05:20
Specialty Text Variations
01:25
Discover Whether Element is Displayed, Enabled, Present, Selected...
04:57
Pagination - Clicking Next Until You Reach the Last Page
07:38
Element Position and Size
02:05
Scrolling Element Into View
02:21
Regular Expression Patterns!
13:35
Return Text Based on Regular Expression (RegEx)
04:41
Automatically Download File to Custom Folders with SetPreference()
07:17
SetPreference Extra example!
00:08
+ Built In Comparison Operators
8 lectures 15:46
Assert vs Verify
01:53
Equals Comparison Operator
04:46
Not Equals
00:43
Contains
01:26
Custom Error Messages
01:19
Matches & NotMatches
03:09
Fail, False and True
02:26
Selenium VBA Code Snippets - Chapter 4-6
00:04
+ Mouse and Keyboard Actions
11 lectures 35:13
Click, Click and Hold, Release, Right Click & Double Click
07:07
SendKeys and Keys Modifiers
05:18
KeyDown, KeyUp
02:07
Exercise 07a - Question
00:12
Exercise 07a - Answer
04:21
DragAndDrop - Swapping Elements, Better with JavaScript
05:20
DragAndDrop - Element Disappears Once Dropped
01:28
DragAndDrop - Dragging Text Programmatically
01:17
DragAndDrop - Dragging File for Upload Programmatically
02:38
Hover MenuItem and Click On Submenu Item
04:33
Clear Out Text Entry Element
00:52
+ Timeouts and Waits
13 lectures 39:27
TimeOuts and Wait DEFAULTS
02:26
Basic Wait Command
01:51
Exercise 08a - Question
00:12
Exercise 08a - Answer
03:01
Finding Elements With a Custom TimeOut Duration
03:22
Wait Until Element is Displayed
01:49
Wait For Specific Text or a Specific Attribute to Appear!
07:33
Wait For CSS Special Value to Appear or Change
05:47
Wait for Text To Appear or Change
03:45
WaitNotElement and By.Any
03:55
WaitEnabled or Wait Until Element is Displayed
03:41
Wait For Selection With Checkboxes and OptionButtons
02:01
Selenium VBA Code Snippets - Chapter 7-8
00:04
+ Browser Window Control, Navigation and Focus
22 lectures 01:45:43
Alerts - Using Multi Options (OK and Cancel, OK Only & Text) with An Alert
08:58
SetCredentials Troubleshooting Tips and Authorization Dialog Popups
05:07
Custom Function Testing Whether Dialog Popup Is Present
06:42
Basic Navigation - Back, Forward, Reload, Close Driver, Close Single page, Url
06:11
Setting A Custom Profile For WebDriver Session
07:17
Add Special Arguments to Customize Browser Options - Incognito or Hidden Window
04:52
Special Arguments List
00:06
AddArguments Link and Examples
00:10
Grab Html Page Source and Text From Parent Elements
04:03
Exercise 09a - Question
00:12
Exercise 09a - Answer
04:11
Keep a Permanent WebDriver that Doesn't Close On Its Own
07:02
Frames and Frame Nagivation
07:15
BONUS - Frame Finder Custom Function
10:28
BONUS - Switch To Nested Frame Custom Function
05:55
Window, Tab Manipulation by Title, Index, Previous and Next
06:14
Accessing Window By Name, Handle
02:16
Close All Tabs Except Main Tab
05:25
Several Ways To Open a New Tab In Current Session
03:41
Window Sizing and Position
03:36
Selenium VBA Code Snippets - Chapter 9
00:04
+ Image and Clipboard Manipulation
8 lectures 28:55
Save a Screenshot of Your Browser, Dispose Image in System Memory
04:57
Save Web Element as Image
03:06
Save Entire Desktop Screen as Image
01:52
Copy Image Directly to Excel OR To Clipboard
03:16
Image Dimensions and Resizing
03:55
Put Web Image Into Worksheet ActiveX Image Control
04:08
Load Image Into Userform Image
03:06
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

Using a website has become part of everyday life in both work and play. Many of us spend hours a day scouring the web or filling out tedious forms online for work!

But what if we can automate these processes that steal our precious time away from us? Introducing “Complete Web Automation with Excel VBA” course. In this jam-packed, progressive course, I share over eight hours of secrets to using the popular website testing program called Selenium, ( previously only available using complicated web languages such as JavaScript or PHP). This free tool is now available to all Microsoft Excel users, but there’s very little documentation for how to use it unless you are a web developer.

Throughout the course, I take you through all the undocumented processes, enabling you to locate and interact with any element on a webpage using a variety of strategies, from basic text & attribute searches to Advanced strategies such as XPath, CSS Selectors, and Regular Expression (RegEx) functionalities.

You’ll learn how to fill out web forms dynamically, navigate web pages intuitively, and extract and manipulate data to increase efficiency.

Once you understand how to find an element (or group of elements), you'll learn to evaluate whether elements are hidden, enabled or disabled, visible, selected, checked or unchecked, and then we'll show you how to completely control mouse and keyboard commands and positioning. Then we’ll learn how and when to trigger macros with precision using "Timeouts and Waits"!

In addition to basic navigation, I'll show you how to Open, Access and Toggle multiple tab Windows, how to resize, re-position and auto-scroll your browser window as well as use login techniques with set credentials. You'll be able to deal with pop-ups, alerts, notifications and Frames like an expert. I'll even show you the secrets of controlling the clipboard, saving screenshots to your Excel file or even taking all or parts of online tables into your spreadsheets automatically. Finally, I'll take you through drop down menus and working with list boxes to complete your WebDriver mastery.

The course comes loaded with several examples in each section, including several engaging and challenging exercises to help you solidify what you've learned (with solution videos immediately following).

You’ll receive 100% of the source code, downloadable materials and course workbooks instantly, yours to keep FOREVER. In addition, you’ll receive LIFETIME ACCESS to the course videos, including updates, BONUS videos and lectures as they come out and any future source code and workbooks – Yours to keep – FREE.

All students will receive LIFETIME ACCESS to ask me any questions about the materials in the FORUM section – as well as chat with other students and help each other. As always, this is backed by a 30 day 100% No questions asked refund as well.

So Stop wasting your time with tedious online tasks when you can automate your online workflow Today!

Order “Complete Web Automation with Excel VBA” course Now!

Who this course is for:
  • This Excel course is for anyone who wants to learn Automation secrets in Excel VBA for controlling websites. No prior programming knowledge is needed.