title: Excel VBA for opening a file with a date in the filename that changes
body: <p>I have an Excel file that is created every day, named <code>"three day outlook 7-7-2014</code>. The date changes every day, but the files are stored by day in a folder, so I have multiple files named <code>"three day outlook"</code> but with different dates. </p>
  
  <p>I am trying to use VBA code to open certain files by date that are selected by a date selection on another Excel sheet. I have tried the following: </p>
  
  <pre><code>Workbooks.Open Filename:=("C:\Users\sdfe\Documents\three day outlook" &amp; Cells(D3).xlsx)
  </code></pre>