title: Excel 2016 for Mac, having issues using a Macro that normally works on 2011
body: <p>I am attempting to run macros on my Mac Excel 2016 version. Unfortunately, I get a run-time error 1004. The code normally works on Mac Excel 2011. Please help, assistance is much appreciated; I am not a coder.</p>
  
  <pre><code>Option Explicit
  Sub copyallworksheets()
  '
  ' copyallworksheets Macro
  ' copy all worksheets to new workbooks
  '
  ' Keyboard Shortcut: Option+Cmd+b
  '
      Sheets("Beverages").Select
      Sheets("Beverages").Copy
      Cells.Select
      Range("A13").Activate
      Selection.Copy
      Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
          False, Transpose:=False
      Cells.Select
      Range("A13").Activate
      ActiveWorkbook.SaveAs Filename:= _
          "Macintosh HD:Users:Jay:Desktop:EOM Uploads:Beverage Purchases.csv", _
          FileFormat:=xlCSV, CreateBackup:=False
      ActiveWorkbook.Close savechanges:=False
  </code></pre>
  
  <p>The 1004 error occurs on the following line:</p>
  
  <pre><code>ActiveWorkbook.SaveAs Filename:= _
          "Macintosh HD:Users:Jay:Desktop:EOM Uploads:Beverage Purchases.csv", _
          FileFormat:=xlCSV, CreateBackup:=False
  </code></pre>