Created by Daniel Strong | Video: 1280×720 | Audio: AAC 48KHz 2ch | Duration: 08:41 H/M | Lec: 138 | 5.05 GB | Language: English | Sub: English [Auto-generated]Fill Out Web Forms Dynamically, Navigate Web Pages Intuitively, And Extract & Manipulate Data To Increase Efficiency!What you’ll learnLocate 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 elementsDeal with Popups, Alerts, Notifications and Frames like a boss!Utilize Attributes to unearth embedded contentPinpoint elements using Relative or Absolute XpathLearn the secret benefits of CSS SelectorsView and Parse inner html document informationUse free extensions and tools to locate best Xpath or CSS SelectorsCapture Groups of Elements into Arrays, Lists or Straight to Excel!Sort and Remove Duplicates from a List ObjectLocate all sub elements of a div, table, or larger parent elementDetermine if element Exists, is Enabled, Hidden, Selected, Checked or UncheckedEvaluate hidden CSS Properties, such as ‘width’, ‘background color’, etcUnderstand Regular Expression (RegEx) patterns and using pattern matchingGet element Position and Size and Scroll element into View when necessaryCreate custom error messages to evaluate comparison (Equality, Contains, NotEquals, Matches, Fail…)Discern the difference between Assert and Verify operatorsProgrammatically hover, click, click and hold, release, right click and double click with the MouseSend Keyboard combination presses as well as regular word character presses to the browserDrag and Drop elements or text to another area or drag files for Upload programmaticallyControl Timeouts and Wait default settings for PageLoad, Element searches and Server timeoutsDelay execution until controls are Visible, Enabled, Text is displayed or changed, Checkboxes/Optionbuttons are selectedWait for CSS special values change or meet conditionsLog In using set credentials to siteTest for the presence of Dialog popupsNavigate with Basic Web Controls – Back, Forward, Reload, Close Driver, Close Single page, UrlsSave and Load specific user profile for WebDriver executionEnter and Exit specific embedded Frame controls and their html contentOpen, Access and toggle multiple tabs/windows and Select by Index, Title or Window HandleResize and Position Browser window to user specificationsSave Screenshot of Browser, Web Element(s), or entire Desktop to Excel or to a fileCopy Image directly to Excel OR to ClipboardChange image dimensions and resizeCompare multiple image files, generating an image of differencesCast image elements into ActiveX Image Control on worksheet or Userform!Convert Web-Table into TableElement Object and manipulate as array or directly to ExcelExtract specific Web-Table column(s) instead of whole table!Dynamically select one or more Dropdown or Listbox options programmatically or using mouse clicksDeselect all options or explore ‘Options’ collection and propertiesRequirementsYou 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.

DescriptionUsing 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.

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.