Complete Web Automation With Excel VBA

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

GET INSTANT ACCESS FOR JUST $48

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

I WANT TO TAKE ADVANTAGE NOW

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.

I WANT TO GET STARTED NOW

What's Included In The Course

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

GET ACCESS NOW

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

ENROLL TODAY

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.

GET STARTED

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
SIGN UP NOW

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.

“Dan! This course is soo awesome! I loved every lecture of this course. My dream of Automating time consuming activities is one step closer just because of this course. Please make a few more courses like this, would definitely sign up for it.”
Gaurav S.
Gaurav S.
“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!”
Victoria
Victoria
“Good course, I does second course in VBA with this instructor. To my mind, Daniel is a God of Excel, his knowledge is unbelievable, I enjoyed”
Oleg S.
Oleg S.
“Good course and lecturer explains in chunks most aspects of Selenium accessible from Excel VBA. The practical short exercises actually work and easy enough to setup my VBA environment to follow hands on. It needs some bigger project or exercise to utilize most of what was learned at the end I think.”
Law C.
Law C.
"Daniel is very responsive to questions. He even posted some new video lectures to address one of my questions specifically. Above and beyond!”
Paul K.
Paul K.
"Excellent course to bridge the gap between VBA and the internet. Webpage manipulation and interaction to extract and use the data in excel takes VBA to a whole new level. If you are looking to close that gap, I highly recommend this course.”
Richard Buckley
Richard Buckley
I love it!!! Easy to understand!!!
Glauciara Kawasake
Glauciara Kawasake
Awesome course. Gave me the exact tools I was looking for. Instructor is energetic, enthusiastic and engaging. Knows his stuff and communicates it well.
Tom Donnelly
Tom Donnelly
Searching for this training since quite long. Finally got it here! Very informative. Concepts very well explained!! Thanks
Sanjay Rawat
Sanjay Rawat
Excellently, thank you for teaching me the short cut without the need to go through the whole VBA
Gin Kiong Lee
Gin Kiong Lee
I never used selenium before but the course is showing me how easy it is to use it. I could really follow it and then created my own program to open a webpage, enter something in the textbox and then click on button and then read the page based on my entry. I am still struggling to wait until the page is fully loaded. The wait time varies on different machines.
Vishal Soni
Vishal Soni
Daniel has created an excellent course, but also has kept the course up-to-date and he add lectures to resolve issues that newer students have seen. He is great at helping students troubleshoot their own projects. Going above and beyond his instructor role to help his students solve their bugs!
Frank Gunseor
Frank Gunseor
Helpful, clear and practical, able to be used almost daily the techniques taught, it covers such a needed area of Excel , left to Python mainly and also R, he covers it here with easy to understand explanations. A real target arrow in your quiver.
John Hopkins
John Hopkins
Well done. Each concept explained so well that as early as section 3 I was able to automate a data entry task that has always been very time consuming. To sit back and watch the automation do that tedious task was very rewarding. I'm all in. Keep up the great work!
Melvin Fine
Melvin Fine
Nicely explained! I already had some knowledge before buying this course and worked on more than 20 VBA/Selenium Macros but what I knew it was not enough. With the info that I've learned thus far I've managed to speed up my macros and make them more stable.
Tudurachi Gabriel
Tudurachi Gabriel
Previous
Next

30-DAY MONEY BACK GUARANTEE

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

ADD TO CART NOW

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 Policy – Terms 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
    Continue Shopping