Forum Discussion
VBA: Save file as .csv with sequential numbering
Good day Community, I am trying to save one sheet from a macro-enabled file as a .csv document. I will need to save it every month so each month I would like to save the file with a new number (e...
Since you're on Mac, I think the line
filePath = "/Users/xxxx/Desktop/Testing Save As.xlsm" & "\"
should be
filePath = "/Users/xxxx/Desktop/Testing Save As.xlsm" & "/"
But do you really have an extension .xlsm in the file path?