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.
7 freelancers are bidding on average $148 for this job
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.