title: How can I use VBA in Excel to find a free slot in the other persons calendar and pull back in to my sheet?
body: <p>I have a excel spreadsheet with names, emails, Meeting date and meeting times, How can i get ans import a time slot from a recipients calendar to make/suggest an appointment time and get that info back in to the excel spreadsheet while making sure the dates and times fall within 9-5 Mon-Fri</p>
  
  <p>Please bare in mind Im still quite new to VBA so code would be fantastic and instructions would be even better :)</p>
  
  <p>Thanks</p>
  
  <p>(Thanks for the "-1" on my question too :D )</p>
  
  <hr>
  
  <p>So far i have managed to get excel -> outlook to get the information only when i specify a set date and a set user eg;</p>
  
  <pre><code>Public Sub GetFreeBusyInfo()
  
      'launch Outlook
      Dim olapp As Outlook.Application
      Set olapp = CreateObject("Outlook.Application")
      Dim myNameSpace As Outlook.Namespace
      Set myNameSpace = olapp.GetNamespace("MAPI")
      Dim myRecipient As Outlook.Recipient
      ' who's calendar
      Set myRecipient = myNameSpace.CreateRecipient("person@email.com")
      Dim myFBInfo As String
      On Error GoTo ErrorHandler
      'when and how long to look for
      myFBInfo = myRecipient.FreeBusy(#1/30/2014#, 60 * 24, True)
      MsgBox myFBInfo
      Exit Sub
  ErrorHandler:
      MsgBox "Cannot access the information. "
  End Sub
  </code></pre>
  
  <p>, but it is reporting back im the message box something like "001010101101101011100100" I understand that in my case its saying 0= free and 1= busy but how can i change that back to a manageable date and time that i can then drop the msgbox and insert it to a cell?</p>
  
  <p>Also would it be best to screen the out of hours times before or after pulling the info back to excel as im only looking for one date and time?</p>