Scraping data from a webpage with getElements using Visual Basic for Applications.
- in Excel click File tab and goto Options
- in Options, navigate to Customize Ribbon
- under Main tabs, ensure that the checkbox for Developer is in check
- in Developer tab click Visual Basic to open the editor
Right-click
on Project-VBAProject Window and selectImport File
- navigate the
.bas
file to be imported
- goto Visual Basic Editor
Right-click
on Project-VBAProject Window and selectInsert
→Module
from the context menu- start coding ❤️
- to run the code: simply press
F5
to execute the whole code orF8
to run it by line