title: Saving Excel workbook to constant path with filename from two fields
body: <p>I tried to search and put together a code to fit my purpose.</p>
  
  <pre><code>Sub save()
  ActiveWorkbook.SaveAS Filename:="C:\-docs\cmat\Desktop\New folder\ck.xls", FileFormat:= _
    xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _
    , CreateBackup:=False
  End Sub
  </code></pre>
  
  <p>How to edit this to:
  Instead of naming the saved file ck.xls, generate the filename from the worksheet cells C5 and C8, with a space in the middle.      </p>