title: How to save a worksheet as another workbook with a dynamic name?
body: <p>I understand how to save a worksheet as a new workbook, but how do I can specify the name dynamically?
  I've tried both <code>Save As</code> and <code>Save</code> as filename but I can't figure out how to put a variable into the name successfully.</p>
  
  <pre><code>Sub sheetCopy()
  
     Dim wbS As Workbook, wbT As Workbook
     Dim wsS As Worksheet, wsT As Worksheet
     Dim title As String
  
     title = ThisWorkbook.Worksheets("IR General Info").Range("B2").Text
  
     Set wbS = ThisWorkbook 'workbook that holds this code
     Set wsS = wbS.Worksheets("Bulk Upload")
  
     wsS.Copy
     Set wbT = ActiveWorkbook 'assign reference asap
  
     Set wsT = wbT.Worksheets("Bulk Upload")
     wsT.Name = "Exported_BulkUpload" 'rename sheet
  
     wbT.SaveAs wbS.Path &amp; "\" &amp; title &amp; ".xlsx"
  
  End Sub
  </code></pre>
  
  <p>So If I make title something like "boo" with quotes - this code works. But how do I make it change based on the variable title?</p>