title: Getting all of a file's properties with VBA
body: <p>I'm trying to read and write a list of properties from files (mainly doc and xls), like Title, Author, Tags or Comments. I can easily get basic attributes, but not these extended ones.</p>
  
  <p><strong>GetDetailsOf</strong> used to work ( <a href="https://technet.microsoft.com/en-us/library/ee176615.aspx?f=255&amp;MSPPError=-2147217396" rel="nofollow noreferrer">https://technet.microsoft.com/en-us/library/ee176615.aspx?f=255&amp;MSPPError=-2147217396</a> ) however now it stops dead at index <strong>6</strong>.</p>
  
  <p>According to the Docs ( <a href="https://docs.microsoft.com/en-us/windows/desktop/shell/shellfolderitem-extendedproperty" rel="nofollow noreferrer">https://docs.microsoft.com/en-us/windows/desktop/shell/shellfolderitem-extendedproperty</a> ) <strong>.ExtendedProperty</strong> is supposed to be able to read attributes, but it doesn't return most of them. For example Author(s), which is even cited as an example in the link above (<em>There are two ways to specify a property. The first is to assign the property's well-known name, such as "Author"</em>), returns nothing. </p>
  
  <p>Is there another way?</p>
  
  <p>Test script for a single file:</p>
  
  <pre><code>Sub PrintDocumentProperties()
  
      With CreateObject("Shell.Application").Namespace("D:\VBA")
          MsgBox .GetDetailsOf(.Items.Item("derp.xlsm"), 5) &amp; vbNewLine &amp; _
           .Items.Item("derp.xlsm").ExtendedProperty("Date modified") &amp; vbNewLine &amp; _
           .Items.Item("derp.xlsm").ExtendedProperty("Type") &amp; vbNewLine &amp; _
           .Items.Item("derp.xlsm").ExtendedProperty("Size") &amp; vbNewLine &amp; _
           .Items.Item("derp.xlsm").ExtendedProperty("Author") &amp; vbNewLine &amp; _
           .Items.Item("derp.xlsm").ExtendedProperty("Authors")
      End With
  
  End Sub
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/qn03f.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/qn03f.png" alt="enter image description here"></a></p>