Search "All People's Calendar" using VBA code

  • Thread starter Thread starter Sunil
  • Start date Start date
S

Sunil

Hi,

in my company there are nearly 150+ conference rooms which are situated in
different offices/facilities. If i want to book a conference room for a
particular day and during a particular time, i have to go through each and
every conference rooms to look whether any free slot is available during my
desired date and time, which all you know that its time consuming.

is it possible to go through each of the conference room booking details
using VBA code (which in turn i will use it in excel as a front end), and the
macro will take the input such as date and time, and at the end of search it
will provide you with the list of free slot conference room details.

Thanks
 
If you get each resource mailbox as an AddressEntry object you can use the
AddressEntry.GetFreeBusy() method for that. You can also create a dummy
Recipient object for each resource mailbox using
Application.CreateRecipient() and use the Recipient.FreeBusy method.

Look in the VBA Object Browser Help for Recipient.FreeBusy, which has an
explanation of the arguments you supply to the methods and also has sample
code.
 
Hi Ken,

Thanks. i am novice to this. i tried to search in object browser, i looked
in Excel macro part. can you pls point me to some site where i can find some
example code snippets.

Many thanks for your help.
 
You need to set a project reference to Outlook in your Excel VBA project,
then set the Object Browser to the Outlook reference. Then you can select
Recipient, click F1, and get the help for that which shows you a code
example of using FreeBusy().
 
Back
Top