Excel VBA Script - Trip Price and Availability Matrix

  • Status Closed
  • Budget $30 - $250 USD
  • Total Bids 7

Project Description


I require a VBA script written within Microsoft Excel that will go to [url removed, login to view] AND [url removed, login to view] and will data mine the websites. Based on an example template (attachment provided), the user will provide the CHECK IN and CHECK OUT dates on the left, the VBA script will then find the cheapest available room showing the TOTAL PRICE, AVG PRICE PER NIGHT and ROOM TYPE (which is all info provided on the website) for the given resort and time period. Please note, if a particular day is sold out within the specified date range, the result should be "Sold Out".

Please review the attachment for a mockup.

I want excellent VBA written along with good comments.

On a personal note, when creating this matrix by hand, there came a point in time when the website required me to enter a verification code, to ensure I was a human, so you will need to figure out a way to bypass this.

Please ensure you understand this project and what is required before bidding.

Thank you.

Get free quotes for a project like this
Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online