Excel VBA Script - Trip Price and Availability Matrix


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.

Skills: Excel, Visual Basic for Apps

See more: vba matrix, visual basic price, price for vba for excel, personal website price, cheapest will template, avg com, what is vba in excel, what is vba, what is microsoft visual, vba time, microsoft vba, microsoft project price, microsoft excel vba, microsoft excel price, me vba, find in vba, excel vba with, excel vba and, excel 2013 vba, project on vba, excel/vba, excel vba script, data matrix, excel 2013 vba find date, microsoft excel template

About the Employer:
( 45 reviews ) Naperville, United States

Project ID: #4981089

7 freelancers are bidding on average $148 for this job


Hello please check your inbox for more details.Thx

$228 USD in 4 days
(136 Reviews)

I can help you.provide more details,please.

$120 USD in 3 days
(37 Reviews)

Excel Expert. Please check your PM for details. Thanks.

$133 USD in 5 days
(19 Reviews)

Statistician engineer with 4 years working with excel vba

$122 USD in 3 days
(1 Review)

Consider it done...done professionally!

$155 USD in 3 days
(2 Reviews)

I am very proficient in dealing with word, ppt, access, excel files, and good at VBA programming, I have exceed 6 years of VBA programming experience now. Please trust me, and let expert do it.

$127 USD in 3 days
(1 Review)

God willing, with the experience and skills that I have, I am able to complete the work that you entrusted to me.

$148 USD in 3 days
(0 Reviews)