I need a skilled Excel VBA code for web scraping
Budget: $30 – $250 AUD
I want to create an Excel VBA code for web scraping.
I would like an Excel Macro that can provide single-day hotel prices given a set of hotel names/addresses and dates.
In other words, within Excel, in Column A will be a list of hotels, Column B will be addresses, and row 1 will have various dates.
Upon running the macro, the cells will automatically update with the price of each hotel for the given dates.
In the attached Excel file, upon running the macro, the highlighted cells will be filled in with the prices for the given dates.
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?
https://www.google.com/travel/hotels/entity/CgsIg7zhko7Yh6uSARAB/prices?utm_campaign=sharing&utm_medium=link&utm_source=htls&ved=0CAAQ5JsGahcKEwjQjerv4a78AhUAAAAAHQAAAAAQAw&ts=CAESABogCgIaABIaEhQKBwjnDxADGA4SBwjnDxADGA8YATICCAIqCQoFOgNVU0QaAA&rp=OAE
I would like an Excel Macro that can provide single-day hotel prices given a set of hotel names/addresses and dates.
In other words, within Excel, in Column A will be a list of hotels, Column B will be addresses, and row 1 will have various dates.
Upon running the macro, the cells will automatically update with the price of each hotel for the given dates.
In the attached Excel file, upon running the macro, the highlighted cells will be filled in with the prices for the given dates.
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?
https://www.google.com/travel/hotels/entity/CgsIg7zhko7Yh6uSARAB/prices?utm_campaign=sharing&utm_medium=link&utm_source=htls&ved=0CAAQ5JsGahcKEwjQjerv4a78AhUAAAAAHQAAAAAQAw&ts=CAESABogCgIaABIaEhQKBwjnDxADGA4SBwjnDxADGA8YATICCAIqCQoFOgNVU0QaAA&rp=OAE