Will someone please let me know How to import a folder of .xlsx files and save each file as .csv file in the same folder?
I found the Directory tool to read the folder and now what.
Thank you
@TimOzirsky one way of doing this with the batch macro
I am sorry, that didn't work for me.
I should have said that I want the work flow to open each xlsx file and save each file as a csv file using the xlsx file name in the same folder.
For example, open B0-0.xlsx and save it as B0-0.csv.
Thank you
@TimOzirsky That is exactly the above workflow does, what is the error you are facing?
I can't find any files created by the macro. Do I need to edit a path somewhere or ?
Thank you