title: VBA macro to save excel file using path from cell
body: <p>I'm trying to save out a file using a combination of hard line and cell value to determine the file path. </p>
  
  <p>In cell <code>A29</code>, I have a formula that outputs this: </p>
  
  <blockquote>
    <p>2014\January\High Cash 1.7.14</p>
  </blockquote>
  
  <p>I'm getting an <em>Expected: end of statement</em> error.</p>
  
  <p>The code is:</p>
  
  <pre><code>ActiveWorkbook.SaveAs Filename:="S:\IRD\Tamarac\Daily High Cash Reporting\&amp; Range("A29").Text &amp; ".xlsx", FileFormat:= _  xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _ , CreateBackup:=False
  </code></pre>