![]() ![]() The code works up until the ActiveWorkbook.SaveAs Filename:=newFileName, FileFormat:=6, CreateBackup:=False line, which then throws the error: While a similar issue was documented here ( Getting "method saveas of object _workbook failed" error while trying to save an XLSM as CSV), unfortunately while changing xlCSV to 6 worked for them, this has not worked for me. ![]() 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 export a CSV. The macro works on Windows platforms with Excel 2016, and on Mac platforms with earlier than the 2016 version. I am running a VBA macro in Excel 2016 for Mac.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |