Hi,
I have the following code, which saves / exports all worksheets within a single .xlsx file to separate .xlsx files in the same file path location:
Is there a way that I can amend this to work so that it saves the files in .csv format instead. I have tried a few things (see a related post here: VBA to save all worksheets as separate .xlsx files - macOS), but none have worked so far - despite working for the suggesting user on Windows OS.
Below is one of the suggestions, but despite working on Windows, it didn't work for my Mac. Guessing there must be a different file type part to make it work, rather than 'xlCSVUTF8'.
Also posted on MR. EXCEL: https://www.mrexcel.com/board/thread...macos.1237649/
Thanks in advance!
Bookmarks