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!