Complete Web Automation with Excel VBA

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