title: How to do a "Save As" in vba code, saving my current Excel workbook with datestamp?
body: <p>I have an Excel Workbook that on form button click I want to save a copy of the workbook with the filename being the current date.</p>
  
  <p>I keep trying the the following
  <code>ActiveWorkbook.SaveAs ("\\filePath\FormFlow To MSExcel\" &amp; Left(Now(), 10))</code> but am receiving <code>Run-time error '1004': Method 'SaveAs' of object'_Workbook' failed.</code></p>
  
  <p>Can anyone assist me with this? I'm still very new to developing for Excel.</p>