title: How to set a filepath in VBA that will vary based on the month?
body: <p>I'm having an issue. Currently I have a couple vb modules working off one another that when executed will increment a drop down list, save a version of each option on the drop down list, and print out a copy as well. </p>
  
  <p>Right now I'm using this filepath. </p>
  
  <pre><code>Sub G5()
      'Update 20141112
      Dim Path As String
      Dim filename As String
      Path = "C:\Users\MY.Name\Documents\Testing\" &amp; _
              Range("G5") &amp; "\" 
      filename = Range("G5")
      If ActiveSheet.Range("G5").Value = "" Then End
      If ActiveSheet.Range("G5").Value = "NAMES" Then Exit Sub
      ActiveWorkbook.SaveAs filename:=Path &amp; filename &amp; "-" &amp; Format(Date, "mmddyyyy") &amp; ".xlsm", FileFormat:=52
  End Sub
  </code></pre>
  
  <p>So cell G5 contains the name (Last, First) of the person whose voucher this is. Each name is data validated and is identical to the name of their individual folder. Currently the script will save to their folder, but within those folders are 12 sub folders, one for each month. Is there any way for me to get the files to save into the correct month folder? </p>
  
  <p>Cell I10 is the only cell that mentions the month by name, but in the format of "June Transit Reimbursement" </p>
  
  <p>Any help would be appreciated. The script above runs in conjunction with two others, and although its doing 95% of what I need it to do, if I can get past this final hurdle the process will be 100% automated. </p>
  
  <p>I'm trying to read through Like Operators and Option Compare Statements, but I'm struggling, and after reading so many posts here am hoping someone can help</p>