title: Open SharePoint file with part of filename
body: <p>How do I open a SharePoint file using part of the filename?</p>
  
  <p>I have a file that is updated every year (Demand 2016, Demand 2017 etc.)</p>
  
  <p>I currently link the file with the SharePoint url.</p>
  
  <pre><code>Set wb = ThisWorkbook
  Set demandWB = Workbooks.Open("http INSERT URL Demand%20Plan%2016.xlsm")
  </code></pre>
  
  <p>I want to find the file with "Demand" in the name.</p>