title: Excel VBA Saving with Variable Name
body: <p>Soo.... having a problem saving the excel with as the name i want it to generate.. it keeps saving as &quot;FALSE&quot;... from what i can tell I have everything correct.  Since the directory will be a variable I rather just have it save in the current folder.</p>
  <p>Ultimately I want it as Week # m-d-yy Site.xlsm
  e.i Week 36 9-5-20 41st HMU</p>
  <pre><code>Sub SaveWorkBook()
  
  
      Dim wb As Workbook
      Dim myFile As String
      Dim dDate As Date
      Dim sSite As String
  
      dDate = Date 'Todays date
      sSite = Range(&quot;Q10&quot;).Value 'Site Name
      
      myFile = &quot;Week &quot; &amp; WorksheetFunction.WeekNum(dDate, 2) &amp; Format(dDate, &quot;m-d-yy&quot;) &amp; &quot; &quot; &amp; sSite &amp; &quot;.xlsm&quot;
      
      Application.DisplayAlerts = False
          
      ActiveWorkbook.SaveAs FileName = myFile
    
  End Sub
  </code></pre>