Open Outlook Calendar in the same window, using VBA

Hi

I have Outlook 2010 and (manually) I can switch on another shared calendar by just clicking the box before it in My Calendars.

But I would like to be able to do this progammatically.

I have tried the code below, which works but does NOT open the calendar in the same window.

I have tried using ActiveExplorer which I believe should allow Outlook to open the calendar in the same window, but without success.


Any help would be greatly appreciated.

Malcolm

Sub test()
Dim myOlApp As Outlook.Application
Dim myNamespace As Outlook.NameSpace
Dim myRecipient As Outlook.Recipient
Dim CalendarFolder As Outlook.MAPIFolder
Set myOlApp = CreateObject("Outlook.Application")
Set myNamespace = myOlApp.GetNamespace("MAPI")
Set myRecipient = myNamespace.CreateRecipient("desk1tr1")
myRecipient.Resolve
If myRecipient.Resolved Then
Call ShowCalendar(myNamespace, myRecipient)
End If

End Sub

Sub ShowCalendar(myNamespace, myRecipient)
Dim CalendarFolder As Outlook.MAPIFolder
Set CalendarFolder = _
myNamespace.GetSharedDefaultFolder(myRecipient, olFolderCalendar)
CalendarFolder.Display
End Sub