Instructions to save to a folder created within the depths of your Office system files, as that is the only one with correct permissions, somehow. There is no update or solution to the issue, other than that it is likely a permissions problem specific to Office 2016 for Mac which has occurred on multiple machines. Then reverted back to the working code, it stopped working.įor anyone who finds this thread, the most recent version of the conversation is here:

For some reason, it worked randomly about 10 times (only in one directory, if the workbook was moved to another directory and I tried to run the code, it would throw the 1004 error) and then when I commented out a line of code, tried something else, and.

Which throws the error Run-time error '1004': SaveAs method of Worksheet class failed.

Changing the problematic line to Sheets('OfflineComments').SaveAs Filename:=newFileName, FileFormat:=6, CreateBackup:=False.

Trying the code mentioned in the above-linked article, which did not help (and which is why I am posting the original code here).

Various file types for the FileFormat parameter, but as mentioned, only two types actually worked.

Ensuring that version of Excel is checked for and permissions allowed by user.

Adding a full path to the input/output file names.

MsgBox ( 'Offline comments exported to ' & newFileName ) Application. SaveAs Filename := newFileName, FileFormat := 6 , ' Check if software is Office 2016 for MacįilePermissionCandidates = Array ( wsPath )įileAccessGranted = GrantAccessToMultipleFiles ( filePermissionCandidates )ĪctiveWorkbook. NewFileName = Mid ( oldFileName, 1, InStrRev ( oldFileName, '.' ) - 1 ) & timeStamp & '.csv' TimeStamp = Format ( Now, 'yyyymmddhhmmss' ) However, if FileFormat is set toĦ (.csv) the code will throw the error above. Run-time error '1004':Method 'SaveAs' of object '_Workbook' failedĥ3 (.xlsm) the code will successfully finish. The code works up until the ActiveWorkbook.SaveAs Filename:=newFileName, FileFormat:=6, CreateBackup:=False line, which then throws the error: Neither of the solutions worked for me (one solution was changing the FileFormat parameter toĦ from xlCSV and the other was to replace / in a file path with 'method saveas of object _workbook failed' error while trying to save an XLSM as CSV) and here ( ), While a similar issue was documented here ( Getting The code is supposed to allow the user to click a button, which will then export an active worksheet to a CSV file. The issue appears specific to Excel 2016 for Mac when trying toĮxport a CSV.

The macro works on Windows platforms with Excel 2016, and on Mac platforms with earlier than the 2016 version.

I am trying to run a VBA macro in Excel 2016 for Mac.

Vba in excel 2016 for mac