Web Data Scraping using Excel VBA

Learn how sub procedures and functions work in vba, including scope, private vs public access, passing arguments, and returning values with practical message box examples.

Learn to implement conditional statements in Excel VBA using if, else, and nested blocks, plus select case with input boxes and days of week examples to handle various decision paths.

Explore string operations in Excel VBA for web data scraping, using Len, Left, Right, Mid, Split and Join to extract, split, and format strings with arrays and loops.

Explore automating Internet Explorer with Excel VBA using Microsoft Internet Controls and the Microsoft HTML Object Library to navigate pages and interact with page elements by ID, name, or tag.

Launch and close a browser in Excel VBA by creating an Internet Explorer object, making it visible, and navigating to a URL, then quitting the browser.

Learn to control open browser in excel vba using Microsoft Internet Controls and ShellWindows to enumerate IE and File Explorer windows, filter by url, and navigate to YouTube or amazon.com.

Explore the types of web elements—text fields, links, buttons, images, checkboxes, radio buttons, list and combo boxes, tables and frames—and learn to locate and interact with them using Excel VBA.

Learn how HTMLDocument and the document object represent the page, manage load times with a hardcoded five-second wait, and access elements using methods like element by id.

Identify elements using id, name, and tag name locators; manipulate text boxes, a combo box, radio buttons, and checkboxes with Excel VBA in web scraping.

Learn to automate form filling with Excel VBA by populating text boxes, dropdowns, radio buttons, and checkboxes, then submitting the form and handling browser ready state.

Automate filling a web form for multiple records by looping through Excel VBA data, reading names, selecting gender, checking boxes, and mapping dropdowns by index.