Extract Outlook meeting request sent status in excel.

Hello Experts,

Could you please assist me with Excel VBa code to Extract Outlook meeting invite status.


For example if i have sent 5 meeting request from outlook.. i want to know how many of the attendees have accepted my meeting request..

All to be done via vba excel..

I have code which send 5 meeting requests via excel spreadsheet. Only dont know how to get information in excel sheet of how many have accepted...


Unfortunately customer dont want anything in outlook vba... only excel vba is allowed..



I tried google but didnt get any code in specific..

Plz suggest.. thank you..