Complete Web Automation with Excel VBA

Focused View

Daniel Strong

9:58:32

13 View

01 - Introduction - Getting Started & Setup

001 Course-Files-CWAEV-1.8.zip

001 Introduction and Course Download Files.mp4

03:07

001 SeleniumBCDS-1.4.zip

002 Getting FAST Help and Other Freebies with Excel Ninjas Group.mp4

02:05

003 Getting & Installing Selenium.mp4

07:30

004 Installation Troubleshooting (skip if you dont need this!).html

02 - Selenium Basics

001 Opening a Web Page with Multiple Browsers (2 Methods).mp4

09:23

002 Web Elements 101 - Type in Textbox and Click Search Button (ID,Name Selectors).mp4

09:21

003 HTML Overview - Popular Tags and Attributes.mp4

10:02

003 html-Tag-Cheat-Sheet.pdf

004 Strategies - Tag.mp4

04:16

005 Awful-Valentine Site Expired, But We Downloaded It!.mp4

02:42

006 Strategies - Class.mp4

04:45

007 Exercise 02a - Question.mp4

00:12

007 exercise-02a-question.zip

008 Exercise 02a - Answer.mp4

04:49

008 exercise-02a-answer.zip

009 Strategies - LinkText.mp4

01:19

010 Looking At Attributes - More Than Just TEXT!.mp4

03:13

011 Strategies - PartialLinkText.mp4

01:38

012 Strategies - CSS Selectors Intro.mp4

07:16

013 How to Install a Chrome Extension.mp4

00:57

014 CSS Selector Helper for Chrome.mp4

03:57

015 CSS Selector Tool - ChroPath and Technical Demonstration.mp4

08:39

016 BONUS - ChroPath Serious Upgrades - Now Called SelectorsHub.mp4

10:20

017 BONUS - Set Value versus SendKeys To TextBox.mp4

11:14

017 bonus-fill-textboxes-quickly-with-js.zip

018 BONUS - Create or Change Any Attribute Using Javascript.mp4

10:49

019 BONUS - New Change Attribute Custom Function and Huge Demo.mp4

08:30

020 Set Attributes With JavaScript Easily!.html

03 - Advanced Find With XPath

001 Introduction to XPath.mp4

05:04

002 XPath Helper Tool.mp4

04:12

003 ChroPath with XPath for Relative and Absolute Reference Types.mp4

05:08

004 XPath Function - Contains().mp4

04:02

005 XPath Function - Text().mp4

01:45

006 XPath Function - AND, OR.mp4

02:23

007 XPath Function - Starts-With().mp4

01:00

008 XPath - Axes.mp4

07:22

009 XPath Function - Last().mp4

02:32

010 Selecting a Specific Index for XPath Query!.mp4

03:49

011 Exercise 03a - Question.mp4

00:12

011 exercise-03a-question.zip

012 Exercise 03a - Answer.mp4

07:54

012 exercise-03a-answer.zip

013 More XPath Resources.html

014 Selenium VBA Code Snippets - Chapter 1-3.html

014 Selenium-VBA-Code-Snippets-Chapter-1-3.pdf

04 - Working With Multiple Elements At Once

001 Working With a Group Of Elements (FindElements).mp4

04:34

002 Looping Through a Set of Elements, Declaration Tips.mp4

04:11

003 Grab the Text For Each Element Into A List.mp4

03:05

004 Grabbing All Attribute Values into a List.mp4

01:19

005 Add, Remove or Change an Element from a List.mp4

05:02

006 Get Count of List Items or Web Elements.mp4

01:35

007 Remove Duplicates Elements from List.mp4

01:02

008 Sorting Your List.mp4

00:57

009 Importing Items to Excel Directly!.mp4

01:55

010 Looping Through a List of Attributes for a Set of Elements.mp4

08:23

011 Exercise 04a - Question.mp4

00:12

011 exercise-04a-question.zip

012 Exercise 04a - Answer.mp4

06:15

012 exercise-04a-answer.zip

013 Finding Elements within an Element.mp4

03:19

05 - Element Properties, Methods and Useful Information

001 Find the Active Element.mp4

03:16

002 Understanding the By Object.mp4

02:33

003 Does The Element Exist Using By Object.mp4

02:18

004 Does Element Exist Using WebElement Object (2 Ways!).mp4

04:24

005 Value, Tagname, Text & Css Properties.mp4

05:20

006 Specialty Text Variations.mp4

01:25

007 Discover Whether Element is Displayed, Enabled, Present, Selected.mp4

04:57

008 Pagination - Clicking Next Until You Reach the Last Page.mp4

07:38

009 Element Position and Size.mp4

02:05

010 Scrolling Element Into View.mp4

02:22

011 Regular Expression Patterns!.mp4

13:35

012 Return Text Based on Regular Expression (RegEx).mp4

04:41

013 Automatically Download File to Custom Folders with SetPreference().mp4

07:17

014 SetPreference Extra example!.html

06 - Built In Comparison Operators

001 Assert vs Verify.mp4

01:53

002 Equals Comparison Operator.mp4

04:47

003 Not Equals.mp4

00:44

004 Contains.mp4

01:26

005 Custom Error Messages.mp4

01:19

006 Matches & NotMatches.mp4

03:09

007 Fail, False and True.mp4

02:26

008 Selenium VBA Code Snippets - Chapter 4-6.html

008 Selenium-VBA-Code-Snippets-Chapter-4-6.pdf

07 - Mouse and Keyboard Actions

001 Click, Click and Hold, Release, Right Click & Double Click.mp4

07:08

002 SendKeys and Keys Modifiers.mp4

05:19

003 KeyDown, KeyUp.mp4

02:07

004 Exercise 07a - Question.mp4

00:12

004 exercise-07a-question.zip

005 Exercise 07a - Answer.mp4

04:21

005 exercise-07a-answer.zip

006 DragAndDrop - Swapping Elements, Better with JavaScript.mp4

05:20

007 DragAndDrop - Element Disappears Once Dropped.mp4

01:28

008 DragAndDrop - Dragging Text Programmatically.mp4

01:17

009 DragAndDrop - Dragging File for Upload Programmatically.mp4

02:38

010 Hover MenuItem and Click On Submenu Item.mp4

04:33

011 Clear Out Text Entry Element.mp4

00:52

08 - Timeouts and Waits

001 TimeOuts and Wait DEFAULTS.mp4

02:26

002 Basic Wait Command.mp4

01:51

003 Exercise 08a - Question.mp4

00:12

003 exercise-08a-question.zip

004 Exercise 08a - Answer.mp4

03:01

004 exercise-08a-answer.zip

005 Finding Elements With a Custom TimeOut Duration.mp4

03:23

006 Wait Until Element is Displayed.mp4

01:50

007 Wait For Specific Text or a Specific Attribute to Appear!.mp4

07:33

008 Wait For CSS Special Value to Appear or Change.mp4

05:47

009 Wait for Text To Appear or Change.mp4

03:45

010 WaitNotElement and By.Any.mp4

03:56

011 WaitEnabled or Wait Until Element is Displayed.mp4

03:42

012 Wait For Selection With Checkboxes and OptionButtons.mp4

02:02

013 Selenium VBA Code Snippets - Chapter 7-8.html

013 Selenium-VBA-Code-Snippets-Chapter-7-8.pdf

09 - Browser Window Control, Navigation and Focus

001 Alerts - Using Multi Options (OK and Cancel, OK Only & Text) with An Alert.mp4

08:58

002 SetCredentials Troubleshooting Tips and Authorization Dialog Popups.mp4

05:07

003 Custom Function Testing Whether Dialog Popup Is Present.mp4

06:42

004 Basic Navigation - Back, Forward, Reload, Close Driver, Close Single page, Url.mp4

06:11

005 Setting A Custom Profile For WebDriver Session.mp4

07:17

006 How To Add A Chrome Extension To ChromeDriver Sessions.mp4

06:26

007 Restoring a Web Session Using Cookies (Saved in Object Variable).mp4

09:15

008 Restoring a Web Session Using Cookies (Saved in Worksheet).mp4

04:40

009 Add Special Arguments to Customize Browser Options - Incognito or Hidden Window.mp4

04:53

010 Special Arguments List.html

011 GoogleChromePortable64-07102019.zip

011 GoogleChromePortable-06052019.zip

011 Using a Portable Version of Chrome - GoogleChromePortable.mp4

05:58

012 AddArguments Link and Examples.html

013 Grab Html Page Source and Text From Parent Elements.mp4

04:04

014 Exercise 09a - Question.mp4

00:12

014 exercise-09a-question.zip

015 Exercise 09a - Answer.mp4

04:12

015 exercise-09a-answer.zip

016 Keep a Permanent WebDriver that Doesnt Close On Its Own.mp4

07:02

017 Frames and Frame Nagivation.mp4

07:15

018 BONUS - Frame Finder Custom Function.mp4

10:28

019 BONUS - Switch To Nested Frame Custom Function.mp4

05:55

020 Window, Tab Manipulation by Title, Index, Previous and Next.mp4

06:14

021 Accessing Window By Name, Handle.mp4

02:16

022 Close All Tabs Except Main Tab.mp4

05:25

023 Several Ways To Open a New Tab In Current Session.mp4

03:41

024 Window Sizing and Position.mp4

03:36

025 Selenium VBA Code Snippets - Chapter 9.html

025 Selenium-VBA-Code-Snippets-Chapter-9.pdf

10 - Image and Clipboard Manipulation

001 Save a Screenshot of Your Browser, Dispose Image in System Memory.mp4

04:57

002 Save Web Element as Image.mp4

03:06

003 Save Entire Desktop Screen as Image.mp4

01:52

004 Copy Image Directly to Excel OR To Clipboard.mp4

03:17

005 Image Dimensions and Resizing.mp4

03:56

006 Compare Two Images with CompareTo and DiffCount.mp4

04:35

007 Put Web Image Into Worksheet ActiveX Image Control.mp4

04:08

008 Load Image Into Userform Image.mp4

03:06

11 - Web Scraping & Working With Tables

001 Converting a Web Table to TableElement Object and Inserting into Worksheet.mp4

04:22

002 Manipulating TableElement Data as Array onto Worksheet.mp4

10:54

003 Loop Through Elements in Specific Column Only.mp4

03:40

004 Loop Through Multiple Specific Columns Using OR Operator.mp4

01:15

005 Put Specific Columns into List Object, To Excel Easily.mp4

02:35

006 Exercise 11a - Question.mp4

00:12

006 exercise-11a-question.zip

007 Exercise 11a - Answer.mp4

09:24

007 exercise-11a-answer.zip

12 - Selecting Options from Dropdowns and Listboxes

001 Declare SelectElement, Read and Write Dropdown Control.mp4

04:13

002 Select Using the Index Number.mp4

01:13

003 Select Using Internal Option Value.mp4

02:13

004 All About The Options Collection.mp4

03:48

005 Controlling Multiple Select ListBoxes and Gathering Selected Options.mp4

03:58

006 Using The Mouse To Select Multiple Options.mp4

03:31

007 Deselecting All Options or Specific Options.mp4

02:03

008 Selenium VBA Code Snippets - Chapter 10-12.html

008 Selenium-VBA-Code-Snippets-Chapter-10-12.pdf

009 Exercise 12a - Question.mp4

00:12

009 exercise-12a-question.zip

010 Exercise 12a - Answer.mp4

18:32

010 exercise-12a-answer.zip

13 - BONUS - Extra Troubleshooting Tips

001 Error Loading Extension Help.mp4

06:09

002 Error Loading Extension Help - Source Code.html

003 BONUS LECTURE.html

003 bonus-lecture.pdf

Description

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

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

Who is this 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.

What You Need to Know?

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.

More details

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.

User Reviews

Rating

average 0

Total votes0

Focused display

Excel VBA

Daniel Strong

Instructor's Courses

Dan Strong is a renowned software instructor and efficiency solutions specialist with over 16 years of highly diversified experience in report generation, data analysis, automation, and various other Information Technology (IT) tasks. He is a passionate Excel VBA programmer and has been using Excel since his early teens. He has developed various programs that have improved the lives of those who use them. Dan's passion for teaching led him to start a YouTube channel where he taught Excel VBA, and he has turned thousands of people into Excel programmers. He has been recognized by Microsoft for developing innovative systems and creating effective training strategies. Dan is a founding member of the invite-only Microsoft Office Creators, Excel Creator Program, and Microsoft Tech Community programs. His 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. Daniel is 36 years old and currently resides in Missouri, United States.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.