VBA Convert XLSX to CSV File - Entire Directory

how can i get code please

Is it possible to bring back your code? It has been removed after all this time. Thanks.

Hola me pueden compartir el código porfavor

thank you very much for the lesson. if you add a code for the subfolder, it would be much appreciated.

you should get a million likes :)

Hi Mark! thank you for the code! its really a time saving. Btw, how if I want to save the converted files into a new folder? could you please help me?

Thank you so much!

I want to convert .csv file to .xlsx . Could you please let me know what changes i can made in this code to work as per my requirement.

Not sure why I am only getting on worksheet converted while I have over 10 worksheets in my workbook to be converted to csv files? Your thoughts please.

THANKS FOR SAVING ME! Also, there is a way that makes columns separated with ";" and not with "," ?

Thanks a ton!!!
I don't know anything about VBA and could still use it and get the job one.
Thanks Again!!!!

that's great! is there any way to automatically select sub folders in the target folder

This is great! - Is there a way I can state the specific sheet-names I want it to convert?

Thanks Mark

Disappointed that none of the links to this solution work. Hopefully you can reply with an updated link. Thanks.

Can you give me new link for the code because the current link is not working.

brilliant, thanks for the code!

Run time error '91' occurred. Why?

website seems to be dead

Muito bom parabéns, e obrigado por fornecer o código também. Me ajudou bastante!

What would be needed to add /change so the source and destination paths/folders were different

Thanks a lot Mark!
One question. Some of the files i'm converting has alerts so when the macro open the files these alerts are preventing it to keep running. Is there a way to ignore these alerts so the macro run without any intervention?
Thanks again!

Hi Mark. Could you add "Remove all filters" into the code. If there are any filters it will usually corrupt the csv output. Also there is no link for this code.

Congrats, Mark! Nice content!

the link for code is not opening, kindly help

Hi Mark, excellent script. Can you modify the script where instead of opening the folder dialog box the script should automatically connect to the link of the folder saved in the local path ?

Question: if there are 3 populated sheet and I would like to have only sheet 3 to convert to CSV. what script would you add to make it happen Great tutorial!!!

saved me hours - thanks man!

Thank you.

Just 4 likes? This is awesome. Thank you Mark!

Can you please show us how to convert a CSV file to an xlsx file?