Accessing a shared calendar

[waxwing]

I've have a bit of VBA code in Excel that retrieves all of the
participants for meetings I've scheduled and the person's response
status. My assistant can access my shared calendar but does not have
delegate permission. What code would I use to choose the appropriate
shared calendar? Once that calendar is chosen, I'm assuming I can
process the items as I do with the default calendar.

Thanks.

- John

[Sue Mosher [MVP-Outlook]]

Take a look at the Namespace.GetSharedDefaultFolder method.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"waxwing" <waxw...@gmail.com> wrote in message news:1152538962.1...@m79g2000cwm.googlegroups.com...

[waxwing]

Thanks, Sue. That helped alot. I've got my app working so that I can
enter a name and then retrieve that person's shared calendar.

Next question. How can I retrieve the names of the "Other Calendars"
that I see in my calendar window? I'm thinking it might be more
efficient for me to create a list of those shared calendars and then
have the user pick from the list rather than typing in the name. (Less
chance of error.)

Thanks a bunch.

- John

[Sue Mosher [MVP-Outlook]]

Outlook provides no way to do that.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"waxwing" <waxw...@gmail.com> wrote in message news:1152544387.9...@h48g2000cwc.googlegroups.com...

[waxwing]

Bummer. Let's try a different approach.

I've got a cell in Excel named "Organizer". This is where the user of
the template will type the name meeting organizer which is then used in
the GetSharedDefaultFolder(organizer, olFolderCalendar) method. How can
I check to see if that name is equal to the default user so that I can
use GetDefaultFolder instead if I'm the organizer?

Also, I've noticed that when I use the GetSharedDefaultFolder method, a
new reference to that folder such as "Calendar - Peter" shows up the
list of Other calendars. Can I programmatically remove this (similar
to right click and Delete)?

Thank you.

- John

[Sue Mosher [MVP-Outlook]]

You could look at the name of the root folder of the mailbox, in other words, the Parent folder of the current user's Inbox.

Unfortunately, the navigation pane isn't programmable. I know of no way to remove calendar names, except manually.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"waxwing" <waxw...@gmail.com> wrote in message news:1152568515.8...@35g2000cwc.googlegroups.com...

> Bummer. Let's try a different approach.
>
> I've got a cell in Excel named "Organizer". This is where the user of
> the template will type the name meeting organizer which is then used in
> the GetSharedDefaultFolder(organizer, olFolderCalendar) method. How can
> I check to see if that name is equal to the default user so that I can
> use GetDefaultFolder instead if I'm the organizer?
>
> Also, I've noticed that when I use the GetSharedDefaultFolder method, a
> new reference to that folder such as "Calendar - Peter" shows up the
> list of Other calendars. Can I programmatically remove this (similar
> to right click and Delete)?
>
> Thank you.
>
> - John
>
>
> Sue Mosher [MVP-Outlook] wrote:
>> Outlook provides no way to do that.
>>