Course Overview & Disclaimer
  • Course Overview & Disclaimer
VBA refresher [Optional]
  • SubProcedures & Functions
  • Variables and Objects
  • Conditional statements
  • Loop statements
  • Bonus Lecture - String Operations
Web Scraping Libraries(references) & launch operations
  • HTML overview [Optional] - for beginners only
  • Microsoft Internet Controls & Microsoft HTML Object Library
  • Open/close browser and launch url
  • Control already open browser (IE)
Web Automation using Excel VBA
  • Types of web Elements
  • Introduction to HTMLDocument
  • Object Identification techniques
  • Form automation & Browser Readystate
  • Fill form in loop with different data
  • Data extraction from website - Example 1
  • Explanation | Access elements on page | Javascript console and VBA