Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Photoshop Graphic Design Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Meditation Personal Transformation Life Purpose Neuroscience Emotional Intelligence
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Data Science
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Development Programming Languages Excel VBA

Complete Web Automation with Excel VBA

Fill Out Web Forms Dynamically, Navigate Web Pages Intuitively, And Extract & Manipulate Data To Increase Efficiency!
Bestseller
Rating: 4.6 out of 54.6 (710 ratings)
5,024 students
Created by Daniel Strong
Last updated 9/2020
English
English [Auto]
30-Day Money-Back Guarantee

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
Curated for the Udemy for Business collection

Course content

13 sections • 145 lectures • 9h 30m total length

  • Preview03:07
  • Preview04:24
  • Installation Troubleshooting (skip if you don't need this!)
    01:33

  • Preview07:16
  • Preview10:11
  • Preview10:01
  • 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 - ChroPath Serious Upgrades - Now Called SelectorsHub
    10:20
  • Preview11:14
  • BONUS - Create of Change Any Attribute Using Javascript
    10:49
  • BONUS - New Change Attribute Custom Function and Huge Demo
    08:30
  • Preview00:09

  • 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 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
  • Exercise 04a - Question
    00:12
  • Exercise 04a - Answer
    06:15
  • Finding Elements within an Element
    03:19

  • 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

  • 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

  • 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 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

  • 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
  • Preview05:58
  • 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

  • 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
  • Preview04:35
  • 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.

Featured review

Victoria
Victoria
155 courses
13 reviews
Rating: 5.0 out of 57 months ago
Great course! Explained a lot about Selenium and what you can do to QA sites and extract that data out. Similar to Daniel's other VBA courses, he keeps a good pace and goes through a lot of the fine details, from beginner to advanced. Enjoyed the examples and exercises. Thanks again!

Instructor

Daniel Strong
Excel Instructor/Programmer
Daniel Strong
  • 4.5 Instructor Rating
  • 15,458 Reviews
  • 121,822 Students
  • 10 Courses

Hi! My name is Daniel and i'm 31. I've lived most my life in Missouri, United States. I've been using Excel since my early teens, and very early on realized that I absolutely love it. After working on various projects in my spare time for years, improving the lives of those that used my programs, I knew this was more than just a hobby for me; it's my passion. A few years back, I got my first opportunity to program in Excel, but when I landed the job I was asked to re-write my predecessor's coded programs with fancy databases and automated Crystal reports! I found my Excel skills somewhat lacking. I HAD TO LEARN VBA! I studied and studied what I could online and in books, but I wasn't able to learn much that way. I had to dive into my first project for months and months - basically just teaching myself and "figuring it out". I realized that if only someone was out there teaching Excel VBA like Mike Girvin (ExcelIsFun) taught Excel, making everything simple and visual - then Anyone could learn VBA! I started a YouTube channel, mostly for myself as a reference tool, but people started to bite. People flooded my inbox with questions and comments that I was literally changing their lives for the better. My passion is and always has been teaching, and I've turned thousands of people into Excel programmers. Now, with Udemy, I'm going to teach the good stuff - the stuff I kept secret; the Advanced and "not-so-Advanced-but-Awesome" Excel VBA. The things that make people hire you - that make you irresistable and irreplacable. Building REAL Programs, Advanced Reporting and Data Analysis. Dashboards and live data. Automation. My main focus is to create an online community of professional Excel VBA developers and beginners who create Real Programs, solve Real Problems and change Real Lives.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.