Web scraping with Excel and VBA

Excel and VBA can find datas on the web!

Excel can do much more than let you make neat spreadsheets or cool diagrams. With a bit of VBA code, you could for example import web datas from web sites!

The following video shows a web scraping tool that I developed for a customer.

From a list of products references of a given auto parts brand, this macro does the following :

  • Finding URLs of product pages on two webshops
  • Importing prices
  • Copying prices into an Excel chart

You need a web scraping tool? Contact me!

Laisser un commentaire

Votre adresse de messagerie ne sera pas publiée. Les champs obligatoires sont indiqués avec *