title: Copy worksheet into new workbook and save
body: <ol>
  <li>Copy Worksheet 1 in Workbook A</li>
  <li>Create new Workbook (named as below)</li>
  <li>Copy worksheet 1 into new workbook</li>
  <li>Save new workbook as 'abc (daily) &amp; Format(Date, "ddmmmyyy") &amp; ".xlsm" - i.e. code will save in a way that depends on today's date</li>
  </ol>
  
  <p>I'm not sure where I'm making a mistake</p>
  
  <pre><code>'Save Worksheet1 as Workbook
  Worksheets("Worksheet 1").Activate
  With Worksheets("Worksheet 1")
      .copy
  End With
  saveLocation = "X:\abc\abc\abc (daily)" &amp; Format(Date, "ddmmmyyy") &amp; ".xlsm"
  
  ActiveSheet.ExportAsFixedFormat Type:=xlTypexlsm, _
      Filename:=saveLocation
  </code></pre>