title: Save a file with a name that corresponds to a cell value
body: <p>Background: I'm working with a macro that transfers data between different workbooks. One of the workbooks is a conduit for data and doesn't change. The other workbook is a blank form that is populated, saved as a specific name and then reused.</p>
  
  <p>Problem: The workbook being saved needs to use the contents of a cell in the conduit workbook for it's name.</p>
  
  <p>I found a similar post <a href="https://stackoverflow.com/questions/21897456/using-vba-to-save-a-file-in-excel-2010-with-a-different-name-each-time">here</a>. The answer gives me a syntax error.</p>
  
  <pre><code>Sub TestTestTestTest()
  '
  ' TestTestTestTest Macro
  '
  
  '
      Dim name As String
      name = Cells("Contents", A1)
      ActiveWorkbook.SaveAs() Filename:=name**********
  End Sub
  </code></pre>
  
  <p>The starred line is the source of the syntax error.</p>