Using VBA Code to extract data from a website
Closed
varun_1234
Posts
1
Registration date
Tuesday November 26, 2019
Status
Member
Last seen
November 26, 2019
-
Updated on Dec 13, 2019 at 02:51 AM
Concensure Posts 1 Registration date Monday July 20, 2020 Status Member Last seen July 20, 2020 - Jul 20, 2020 at 05:47 AM
Concensure Posts 1 Registration date Monday July 20, 2020 Status Member Last seen July 20, 2020 - Jul 20, 2020 at 05:47 AM
Related:
- Using VBA Code to extract data from a website
- Battery reset code - Guide
- Samsung volume increase code - Guide
- How to get whatsapp verification code online - Guide
- Cs 1.6 code - Guide
- Vba case like - Guide
1 response
Concensure
Posts
1
Registration date
Monday July 20, 2020
Status
Member
Last seen
July 20, 2020
1
Jul 20, 2020 at 05:47 AM
Jul 20, 2020 at 05:47 AM
Hi Varun,
What you are looking for is called webscraping, and needs to be treated on a case by case basis due to different website structure.
You can either follow the
"Simulating Web browser user interaction" section in https://analystcave.com/web-scraping-tutorial/
OR
use the plugin suggested
https://analystcave.com/excel-tools/excel-scrape-html-add/
The first step is always to have a basic understanding of HTML. You will need to learn the basics such as <li> for list, <tag> for tag and <class> for class.
If you just need the information from time to time, you can consider browser plugins for web scraping.
You may also try options without VBA, such as Power Query, and Excel 365's FILTERXML() function. You can also use Google Sheets' ImportXML() function. https://support.geckoboard.com/hc/en-us/articles/207238327-Use-Google-Sheets-ImportXML-function-to-display-data-in-Geckoboard
What you are looking for is called webscraping, and needs to be treated on a case by case basis due to different website structure.
You can either follow the
"Simulating Web browser user interaction" section in https://analystcave.com/web-scraping-tutorial/
OR
use the plugin suggested
https://analystcave.com/excel-tools/excel-scrape-html-add/
The first step is always to have a basic understanding of HTML. You will need to learn the basics such as <li> for list, <tag> for tag and <class> for class.
If you just need the information from time to time, you can consider browser plugins for web scraping.
You may also try options without VBA, such as Power Query, and Excel 365's FILTERXML() function. You can also use Google Sheets' ImportXML() function. https://support.geckoboard.com/hc/en-us/articles/207238327-Use-Google-Sheets-ImportXML-function-to-display-data-in-Geckoboard
