Extracting attendees using VBA - How to pick a desired event that is scheduled to start at a known time with a known subject

  • I modified this online code and have come thus far which works for me by extracting attendees from a given category and saving it on sharepoint excel. However it does not entirely do what I need.


    Question: How to run this macro on one specific calendar event that is known to start at a given time (09:00) for 1Hr and with a known string in the subject "weekly meeting"?.


    Nice to have: How to count Accepted, Declined, Not Responded including the 'Required Attendees' as accepted.