vba-webdata

Scraping data from a webpage with getElements using Visual Basic for Applications.

Importing VBA module:

• open workbook in Excel
  
• press Alt + F11 to open Visual Basic Editor
  
• Right-click on Project-VBAProject Window and select Import File
  
• navigate the .bas file to be imported
  

Create VBA module

• goto Visual Basic Editor
  
• Right-click on Project-VBAProject Window and select Insert → Module from the context menu
  
• start coding ❤️
  
• to run the code: simply press F5 to execute the whole code or F8 to run it by line