title: Excel VBA: How to point to relative directory (name of the file changes a bit everyday)?
body: <p>The current code is: </p>
  
  <pre><code>Set Workbook = Workbooks.Open("Z:\test\bankinfo20180815.xls")
  </code></pre>
  
  <p>The file in the folder would change. For example: it was bankinfo20180814.xls yesterday, bankinfo20180815.xls today and bankinfo20180816.xls tomorrow. So I am wondering how I can specify in VBA code to point to the file that starts with "bankinfo"?</p>