Import Outlook shared calendar into Excel by VBA

[montu]

Hello all,

I've searched the forum and found plenty of code examples that export from Excel into Outlook, but can't find anything to go the other way. I need to import my Outlook shared calendar data(i.e. my team-mates data) into a specific Excel file for building a dashboard that will help me to analyze who is free in the upcoming week.

Please help me to achieve this work....
Thanks in advance!

 

[Mark Risner]

Hi, any update on this topic? There are many ways to export the default outlook calendar, but shared calendars seem to be quite a challenge...