Create code in Excel that will retrieve calendar information from an Office 365 room resource

Project Description Using code available in Excel only, create a macro that will access calendar information for a room resource on an Office 365 account. Retrieve the following information: 1. Email of sender 2. Start Date and time 3. End Date and time 4. Subject 5. Location Deadline Project should be completed by 5 PM Pacific (-8 GMT) on June 27th Key Requirements 1. Code must run from Excel, and not require anything to be installed on the computer. 2. Code must be clearly commented 3. A test environment will be used for development, modification needed to move to production environment must be clearly noted. Project Administration - Questions will be answered between normal business hours of 8AM to 5 PM, Pacific Time (-8 GMT). - Account sing to a test environment will be provided upon award. Suggested reading: [login to view URL] Challenges: - most APIs appear to allow individuals to retrieve their own calendars, but it’s not clear how to retrieve a room resource calendar - Unsure if the code can be executed in VBA