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...
Thank you for your response HansVogelaar
Removing the .xlsm from the file path - when I change it to filePath = "/Users/xxxx/Desktop/Testing Save As" & "/" I get this error message:
When I change it to filePath = "/Users/xxxx/Desktop/Testing Save As" & "\" I get this error message:
In which folder do you want to save the file?
HansVogelaarapologies for the late response. I am trying to save the file to my desktop.
