Outlook access to shared calendar via VBA

Hi All,
I would like to create a macro that gets access from Excel to Outlook Calendar (in order to add appointments from worksheet or so). I managed to do that using my own calendar. However, I wish that there were an access for many users.

I have a calendar shared by another user and I am not able to get access to this (also: he isn't able to open mine, using same script). The code I am using is:

Please Login or Register  to view this content.

Following the instructions from plenty of threads I replaced "GetDefaultFolder" with "GetSharedDefaultFolder".
If I type my name instead of "Another User" it works perfectly, exactly the same as previously. However typing another name brings me a "Run-time error '-2147221233 (8004010f)'": The operation failed" in line "Set olFolder = olNS.GetSharedDefaultFolder(olUser, 9)"


Has anyone any idea what am I doing wrong? Maybe I type a name in wrong format, but - as I mentioned - using mine in same works, and also resolving works same as it should.

Or maybe You have an idea how to omit with - I guess - creating special, opened calendar.


Thank You very much in advance for Your help,

Andrzej

Anyone, any help?