Using Excel VBA to open a specified Outlook Calendar.

[kjharve]

Hi all,

I am trying to write some code that opens a specific Outlook Calendar from Excel VBA. The calendar could be that of any of a number of employees and would be selected by the user.

Opening the default calendar (the user's calendar) is straight-forward but how do I open any other calendar?

As I had no response from the 'Excel Questions' forum, I thought I would try posting this here. Probably because it needs someone with experience with Outlook rather than Excel.

Cheers