Split workbook 400 sheets into separate .xlsx files, but need to be .csv

Hello!

I recently split a workbook with 400 sheets into 400 separate files. They are .xlsx files but I need them as .csv.

Are there any ways of converting 400 .xlsx files to .csv, or splitting a workbook of 400 sheets into separate .csv files?

I would like them to be all in one folder together if possible

I am using mac.

Thanks.

Originally Posted by alansidman

https://www.youtube.com/watch?v=Pzk1Iq5jSxo

Unfortunately when I run this I get:

"Run-time error '91': Object variable or With block variable not set"

when I click debug it highlights:
ChooseFolder.Title = "Select Target Path"

in the video it pops up and he selects the target path but seems to not work for me, maybe because I'm using Excel for mac?

Thanks

I tried the VBA code on Windows and it worked! So the problem was the mac.

Thanks for your help, problem solved.