Hotel Data Scraping via Excel VBA
Budget: $30 – $250 AUD
I want to create an Excel VBA code for web scraping.
Here is a VBA code that I used before but it doesn't work anymore. I need fix this error.
The hotel names, addresses, and dates will change, so the macro must be able to run off the data in the given cells.
Ideally, the macro will use a free API from a trusted source (Google, Expedia, Booking.com, etc.) However,
I realize these API's may not be available. As such, data scraping from one of these websites is acceptable.
As long as its written in the VBA window in Excel
I need to run it directly from excel
Also, if this will be quicker and is
do-able, Google Hotels shows
the hotel prices per night for
several months at a time - would
it be possible to grab two months of data in one scrape?
Here is a VBA code that I used before but it doesn't work anymore. I need fix this error.
The hotel names, addresses, and dates will change, so the macro must be able to run off the data in the given cells.
Ideally, the macro will use a free API from a trusted source (Google, Expedia, Booking.com, etc.) However,
I realize these API's may not be available. As such, data scraping from one of these websites is acceptable.
As long as its written in the VBA window in Excel
I need to run it directly from excel
Also, if this will be quicker and is
do-able, Google Hotels shows
the hotel prices per night for
several months at a time - would
it be possible to grab two months of data in one scrape?