title: Determine if an Outlook event is a meeting and what the response was
body: <p>I'm trying to write a macro in Excel that will look through my Outlook calendar, grab all the events, and display the following information: subject, start time, whether this event was from an meeting invite, and my response.</p>
  <p>I've the first two piece of information down. How do I figure out the last two?</p>
  <pre class="lang-vb prettyprint-override"><code>Dim olApp As Object
  Dim olNS As Object
  Dim olFolder As Object
  Dim olApt As Object
  Dim NextRow As Long
   
  Set olApp = CreateObject(&quot;Outlook.Application&quot;)
  Set olNS = olApp.GetNamespace(&quot;MAPI&quot;)
  Set olFolder = olNS.GetDefaultFolder(9) 'olFolderCalendar
  
  Range(&quot;A1:C1&quot;).Value = Array(&quot;Subject&quot;, &quot;Start&quot;, &quot;Meeting?&quot;, &quot;Response&quot;)
   
  NextRow = 2
  
  For Each olApt In olFolder.Items
      Cells(NextRow, &quot;A&quot;).Value = olApt.Subject
      Cells(NextRow, &quot;B&quot;).Value = Format(olApt.Start, &quot;MM-dd-yyyy&quot;)
      Cells(NextRow, &quot;C&quot;).Value = olApt.MeetingOrNot
      Cells(NextRow, &quot;C&quot;).Value = olApt.MeetingResponse
      NextRow = NextRow + 1
  Next olApt
  </code></pre>
  <p>Obviously MeetingOrNot and MeetingResponse are not valid attributes.</p>