Use the Recipient.FreeBusy method. That approach is also likely to be much
faster overall than reading the full appointments.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx



"JimAnAmateur" wrote:

Anybody has found solution to read duration (start, end) data from other
users' private appointments in Outlook using VBA?

I am writing a VBA (in Excel) which is supposed to make a summary/overview
of all appointments that a group of people have for a specific day (for use
at a "telephone switchboard"). It works fine, except for private
appointments that people may have in their calendars.
myNamespace.GetSharedDefaultFolder seems "ignoring" private appointments in
shared calendars (of course ok with the private appointments of the user who
is running the macro, but not the others' private appointments).

I've been searching on the Internet, the answers I found so far said "no,
it's not possible since a private appointment is a private appointment". Why
is it then possible in Outlook to view graphically "placeholders" of other
users' private appointments? There must be a way of achieving some data
about such appointments. I don't need details, but only "placeholders",
i.e., if there is an appointment, and what is the start time and duration.