title: Excel Vba to open a file using .range as the directory
body: <p>I have a macro that needs to open files but the problem is everyday it is in a new folder labeled according to the day. Example today would be C:\WORK\122315\fileexample.xlsx</p>
  
  <p>How I usually open files with dates is by entering the date in cell A1 as a TEXT "122315" then use Date1 = Range("A1").Value in vba. My question is what do I do if the date is not in the file, but in the subfolder?</p>
  
  <pre><code>    Date1 = Range("A1").Value
  
      ChDir "C:\WORK\Date1"
      Workbooks.Open Filename:= _
      "C:\WORK\Date1\fileexample.xlsx"
  </code></pre>