Make sure that the folder that contains the file is not read-only. Make sure that the specified folder exists Change target to mycsvpath = "/Users/me/Library/Containers//Data/" & ActiveSheet.Name & ".csv".Use ThisWorkbook instead of ActiveWorkbook.I have tried a bunch of stuff suggested by various fora: The perplexing thing is that it works for xlsx files but not CSV. The CSV option never asks, even when I create a new folder for it. The XLSX option popped up the Grant Access dialog for the test folder on the desktop. I have tried to attach it to this message. It has two identical macros - one saves xlsx files and the other (fails to) save CSV files. I have developed a test scenario that wants to save a single sheet with 8 1-character cells from a 1-sheet workbook. The interwebs are rife with people talking about this problem, but sadly unrife with solutions. For weeks now, I have been trying to write a macro to save a bunch of sheets as CSVs from a calculation workbook.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |