title: Appending Username and Date to Save As in VBA
body: <p>How can I save the excel file using vba code so that the Username and Date are attached in a macro?</p>
  
  <p>Here is the code that I worked on to try to make it work:</p>
  
  <pre><code>ActiveWorkbook.SaveAs FileName:=(Environ$("Username")) &amp; "_" &amp; Date &amp; "_BKMtracker.xlsx", FileFormat:=xlOpenXMLWorkbook
  </code></pre>