title: Macro to open file with Current date
body: <p>I am using a macro to open a file that the file name will change each day because of the current date.</p>
  
  <p>File\today_20120723 for today.</p>
  
  <p>I am trying this but it isn't working. Suggestions</p>
  
  <pre><code>Dim OpenPath As String
  Dim OpenName As String
  
  OpenPath = "N:\File\": OpenName = OpenPath &amp; "today_" VBA.Format   (Date, "YYYYMMDD") &amp; ".xlsx"
  
  
  
  Workbooks.Open Filename:=OpenPath
  </code></pre>
  
  <p>Thanks for the help</p>