Forum

Scraping a website ...
 
Notifications
Clear all

Scraping a website with VBA using XMLHTTP GET request

2 Posts
2 Users
0 Reactions
250 Views
(@chiidzzz)
Posts: 1
New Member
Topic starter
 

I want to scrape this page: " https://www.oddsportal.com/matches/soccer/20200318/ " using XMLHTTP GET request. I have a little bit of knowledge as I previously built a c# scraper for this, but I want to do it in excel VBA. Can someone please help me with this matter? I would like to have the result file like the attached imageZL5KZ.jpg

 
Posted : 13/03/2020 3:46 pm
Philip Treacy
(@philipt)
Posts: 1629
Member Admin
 

Hi Chadi,

These articles describe how to do what you want

https://www.myonlinetraininghub.com/web-scraping-with-vba

https://www.myonlinetraininghub.com/web-scraping-multiple-pages

There are also a few topics on scraping in this forum where I've written code which you could use.

If you've written a scraper in C# then doing one in VBA shouldn't be too hard.

Once you get some code together I'd be happy to look at it and give you some pointers if you are having trouble.

Regards

Phil

 
Posted : 16/03/2020 7:07 pm
Share: