Hello,
In order you could have an access to Outlook 365 externally, you could access it from within Outlook Session so when your Outlook able to login to Office 365, you could manage the calendar items directly from VBA. So, make sure you select the correct account in case there are multiple accounts, otherwise use the default one if single account. Using VBA, you will just select the calendar folder by using GetDefaultFolder(olFolderTasks) or GetDefaultFolder(olFolderCalendar), and then you iterate the object within as a CalendarItem objects.
There is a specific way for exporting to new PST file, you should attach a blank new PST file for this purpose. It uses an AddStore method of Outlook namespace object. There is no built-in method for creating new store, so it must use Mapi library or you create a blank PST file.
Let me know if you are interested to discuss it with me.
Best Regards,
Khamid
Note:
- I have my own Office 365 I could use for the development
- per my review there is a method on Namespace object which can be used for creating a new PST file, so we are good to go with purely VBA for Outlook