Complete Web Automation With Excel VBA

Fill out web forms dynamically, navigate web pages intuitively, and extract & manipulate data to increase efficiency!

here's a special discount for you:

As An Excel For Freelancers' Follower, you get an exclusive 10% OFF!

The coupon is auto applied upon checkout...

COURSE OVERVIEW

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.

What's Included In The Course

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

EXERCISES

The course comes 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)

DOWNLOADABLE MATERIALS

You’ll receive 100% of the source code, downloadable materials and course workbooks instantly, yours to keep FOREVER.

LIFETIME COURSE ACCESS

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

COURSE SUPPORT

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.

LEARNING PATH

  • Introduction and Course Download Files
  • Getting & Installing Selenium
  • Installation Troubleshooting

Video: 15 minutes, 4 lectures   

  • Opening a Web Page
  • Web Elements 101 - Type in Textbox and Click Search Button (ID,Name Selectors)
  • Overview - Popular Tags and Attributes
  • Strategies - "Tag"
  • Strategies - "Class"
  • Looking At Attributes - More Than Just TEXT!
  • Strategies - "PartialLinkText"
  • Strategies - "CSS Selectors" Intro
  • How to Install a Chrome Extension
  • CSS Selector Helper for Chrome
  • CSS Selector Tool - ChroPath and Technical Demonstration
  • Create or Change Any Attribute Using Javascript
  • New Change Attribute Custom Function and Huge Demo

Video: 1 hour & 53 minutes, 20 lectures   

  • Set Attributes With JavaScript
  • Intro to XPath
  • XPath Helper Tool
  • ChroPath with XPath for Relative and Absolute Reference Types
  • XPath Function - Contains()
  • XPath Function - Text()
  • XPath Function - AND, OR
  • XPath Function - Starts-With()
  • XPath - Axes
  • XPath Function - Last()
  • Selecting a Specific Index for XPath Query
  • More XPath Resources

Video: 46 minutes, 14 lectures   

  • Selenium VBA Code Snippets - Chapter 1-3
  • Working With a Group Of Elements (FindElements)
  • Looping Through a Set of Elements, Declaration Tips
  • Grab the Text For Each Element Into A List
  • Grabbing All Attribute Values into a List
  • Add, Remove or Change an Element from a List
  • Get Count of List Items or Web Elements
  • Remove Duplicates Elements from List
  • Sorting Your List
  • Importing Items to Excel Directly
  • Looping Through a List of Attributes for a Set of Elements

Video: 42 minutes, 13 lectures

  • Finding Elements within an Element
  • Find The Active Element
  • Understanding the 'By' Object
  • Does The Element Exist Using 'By' Object
  • Does Element Exist Using Web Element Object (2 Ways)
  • Value, Tagname, Text & CSS Properties
  • Specialty Text Variations
  • Discover Whether Element is Displayed, Enabled, Present, Selected...
  • Pagination - Clicking Next Until You Reach the Last Page
  • Element Position and Size
  • Scrolling Element Into View
  • Regular Expression Patterns
  • Return Text Based on Regular Expression (RegEx)

Video: 1 hour & 2 minutes, 14 lectures   

  • Automatically Download File to Custom Folders with SetPreference()
  • Assert vs Verify
  • Equals Comparison Operator
  • Not Equals
  • Contains
  • Custom Error Messages
  • Matches & Not Matches
  • Fail, False and True
Video: 16 minutes, 8 lectures
  • Selenium VBA Code Snippets - Chapter 4-6
  • Click, Click and Hold, Release, Right Click & Double Click
  • Send Keys and Keys Modifiers
  • Key Down, Key Up
  • Drag And Drop - Swapping Elements, Better with JavaScript
  • Drag And Drop - Element Disappears Once Dropped
  • Drag And Drop - Dragging Text Programmatically
  • Drag And Drop - Dragging File for Upload Programmatically
  • Hover Menu Item and Click On Submenu Item

Video: 35 minutes, 11 lectures

  • Clear Out Text Entry Element
  • Time Outs and Wait Defaults
  • Basic Wait Command
  • Finding Elements With a Custom Time Out Duration
  • Wait Until Element is Displayed
  • Wait For Specific Text or a Specific Attribute to Appear
  • Wait For CSS Special Value to Appear or Change
  • Wait for Text To Appear or Change
  • Wait Not Element and By Any
  • Wait Enabled or Wait Until Element is Displayed
  • Wait For Selection With Checkboxes and Option Buttons

Video: 39 minutes, 13 lectures

  • Selenium VBA Code Snippets - Chapter 7-8
  • Alerts - Using Multi Options (OK and Cancel, OK Only & Text) with An Alert
  • Set Credentials Troubleshooting Tips and Authorization Dialog Popups
  • Custom Function Testing Whether Dialog Popup Is Present
  • Basic Navigation - Back, Forward, Reload, Close Driver, Close Single page, URL
  • Setting A Custom Profile For WebDriver Session
  • How To Add A Chrome Extension To Chrome Driver Sessions
  • Restoring a Web Session Using Cookies (Saved in Object Variable)
  • Restoring a Web Session Using Cookies (Saved in Worksheet)
  • Custom Function To Determine If Expiry Date Is Expired
  • Add Special Arguments to Customize Browser Options - Incognito or Hidden Window
  • Using a Portable Version of Chrome - Google Chrome Portable
  • Add Argument Link and Examples
  • Grab Html Page Source and Text From Parent Elements
  • Keep a Permanent WebDriver that Doesn't Close On Its Own
  • Frames and Frame Navigation
  • Window, Tab Manipulation by Title, Index, Previous and Next
  • Accessing Window By Name, Handle
  • Close All Tabs Except Main Tab
  • Several Ways To Open a New Tab In Current Session
  • Window Sizing and Position

Video: 2 hours & 6 minutes, 25 lectures   

  • Selenium VBA Code Snippets - Chapter 9
  • Save a Screenshot of Your Browser, Dispose Image in System Memory
  • Save Web Element as Image
  • Save Entire Desktop Screen as Image
  • Copy Image Directly to Excel OR To Clipboard
  • Image Dimensions and Resizing
  • Compare Two Images with CompareTo and DiffCount
  • Put Web Image Into Worksheet ActiveX Image Control

Video: 29 minutes, 8 lectures

  • Load Image Into UserForm Image
  • Converting a Web Table to Table Element Object and Inserting into Worksheet
  • Manipulating Table Element Data as Array onto Worksheet
  • Loop Through Elements in Specific Column Only
  • Loop Through Multiple Specific Columns Using OR Operator
  • Put Specific Columns into List Object, To Excel Easily

Video: 32 minutes, 7 lectures

  • Declare Select Element, Read and Write Dropdown Control
  • Select Using the Index Number
  • Select Using Internal Option Value
  • All About The Options Collection
  • Controlling Multiple Select List Boxes and Gathering Selected Options
  • Using The Mouse To Select Multiple Options
  • Deselecting All Options or Specific Options
  • Selenium VBA Code Snippets - Chapter 10-12

Video: 40 minutes, 10 lectures

  • Error Loading Extension Help
  • Error Loading Extension Help - Source Code
     

Video: 7 minutes, 2 lectures

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.

WHAT YOU'LL LEARN

What Students Say About The Course

STUDENTS' TESTIMONIALS

Most Awesome Course I've Ever Taken!

His course has allowed me to do things in web scraping more easily than I've ever been able to with the Scrapey framework.

I cannot recommend Dan's course more highly if you're getting started in web scraping. He makes it very simple and easy to follow and easy to do.

FRANK GUNSEOR

Chemical Engineer I IT Professional, C2IT Consulting, LLC

Over 11 Hours Saved Monthly!

The course legit is saving me like four to five hours every couple of weeks whenever I need to run a report. If I didn't have this course, i would have been wasting a ton more time...

Thank you Dan for everything and for answering my questions, really appreciate it.

JIYAAD NAEEM

Salesforce Administrator, Snap Inc.

30-DAY MONEY BACK GUARANTEE

This is backed by a 30-day money back guarantee. No questions asked! 

Frequently Asked Questions

  • You should already have Microsoft Excel for PC or MAC. 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 basic Excel skills needed for this course. If you know Basic to Intermediate Excel VBA, you can surely find more ways to utilize this information, but it is not required as I explain everything in detail.
  • The course will start right away upon signing up, you get instant access.

How would you like access to ALL our Excel courses?

  • Excel Ninja Pro is a subscription streaming service that offers a wide variety of Excel resources, including premium online courses, code vault, swipe files, downloadable workbooks, projects, events, and a results-driven community of Automators.

  • You can watch as much as you want, commercial free - all for one low monthly price. There's always something new coming soon and Ninja Pro members get to help decide what comes next!

Learn more HERE.

Visit the My Courses link at the top left of the site menu. You can also visit the Member's Area and click on Courses tab.

NOTE: You should have an email with a username and link to reset password initially. If not, please check spam folder (if none, contact us immediately or see "How do I change/update my password?" above).

  • Today’s World is full of busy people that want to better themselves, so self-paced programs are popular. Yes, you can learn at your own speed, so that you can focus on things that you find challenging and breeze past things that you already know. You will be the one to decide when to start accessing the course materials and when to finish.
  • Yes, definitely! If you have questions about the lesson, we will answer all your questions as soon as possible.
  • If you’re interested in Web Automation, then you’re on the right track. This course is for everyone, from beginner to advanced Excel enthusiasts.
  • Does lifetime access sounds good to you? You'll have unlimited access to the course once you've enrolled. This means you can re-watch lessons whenever you need and complete the course at your own pace.

Every course in the member's area comes with a 'Certificate of Completion' that you can add to your LinkedIn bio, to your resume or even brag to your friends.

You also get achievement badges the more you participate, comment, and share with the group. You can check out our achievement’s dashboard!

© 2024 – Strong Software Solutions LLC | ExcelVbaIsFun – Privacy PolicyTerms and Conditions
This site is not a part of the Facebook website or Facebook Inc. Additionally, This site is NOT endorsed by Facebook in any way.

FACEBOOK is a trademark of FACEBOOK, Inc.
X

Forgot Password?

Join Us

0
    0
    Your Cart
    Your cart is emptyReturn to Shop