Web availabilty calendar management with Python, Selenium and VBA
Paid on delivery
I have availability calendar hosted on my service provider. Needs are as follows:
1. Read current availability situation from web calendar
2. Mark blocked / available dates to excel spreadsheet (Master calendar)
If a date range is needed to be put blocked / available, there is also a need to:
1. Block availability in web calendar to date range
2. Open availability to date range
More detailed information attached with screen shot from the application and Selenium IDE recording. Temporary access to calendar is given for developement.
Service provider does not have API to control this. This is very unfortunate.
What is expected to be the result:
A VBA code that reads the current availability and updates the excel spreadsheet date value to be “Bolded” if date is blocked/booked and “unbolded” if date is available.
Also selected date range can be either blocked or unblocked with VBA script.
Project ID: #36652268
About the project
31 freelancers are bidding on average €198 for this job
I can create a VBA script that will read current availability from website (using Selenium) and bold / unbold corresponding dates in your Excel spreadsheet. I can complete it in 1-2 days for just €300 EUR. Roman