title: Expected end of statement error when using & to concatenate variables into a file name saveas
body: <p>I'm trying to place a date into a filename but keep getting an "expected end of statement" error. Here is what I have so far:</p>
  
  <pre><code>Sub FileName()
  
  Dim DateFileName As Variant
  Dim SaveNewName As Variant
  
  DateFileName = Format(Date, "mm.dd.yyyy")
  
  
  SaveNewName = "C:\users\matt\desktop\" &amp; "All States #1" &amp; DateFileName &amp; ".xls"
  
  End Sub
  </code></pre>
  
  <p>The file name should read All states #1 3.19.2016, but anytime I use the &amp; symbol to concatenate the .xls I get the expected end of statement error! In fact anytime I try to use it to put three things into a variable I get that error. What am I doing wrong???</p>