Convert Excel Files To CSV Files Using Excel VBA (Excel Automation)

In this Excel Automation tutorial, we will learn how to convert Excel files to CSV files using VBA.
► Buy Me a Coffee? Your support is much appreciated!
-------------------------------------------------------------------------------------------
☕ Paypal: www.paypal.me/...
☕ Venmo: @Jie-Jenn
💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC
► Support my channel so I can continue making free contents
---------------------------------------------------------------------------------------------------------------
🌳 Becoming a Patreon supporter: / jiejenn
🛒 By shopping on Amazon → amzn.to/2JkGeMD
📘 Facebook Page → / madeinpython
📘 More tutorial videos on my website → LearnDataAnaly...
✉️ Business Inquiring: [e-mail]
#excel #vba #excelvba

[@rohitpatil5083]

You made it simple & easy to understand with an example…loved it. Could you please give a code to convert .tdms files to .csv files and save with same name ?

[@adamamer2795]

Works Perfectly!!!! Thank you so much!

[@jonelatendido9836]

Could you send the code?

[@AdAstraLeo]

I’m using mac and I always get the in the line with SaveAs. Seems saving as csv cannot be done in mac, I tried other formats from .xls to .xlsx, your code is working. Hope you can help.

[@sandipdas1]

wb_target.saveas data_file_folder & replace (file name, ".xlsx", ".csv"),6
exception has been thrown by the target of an invocation
Please help

[@hansakaerandaranasinghe6455]

love this!!

[@jiejenn]

👍

[@vasudevg6110]

Please make a video on how to convert CSV to excel file. When I save CSV file some text columns numbers are changed as 0000. How can we convert it with vba

[@jonelatendido9836]

Could you provide the code? It should be helpful that way,. Thanks you so much for this tutorial❤️

[@HappyLife-um2tn]

Will this work if source is from sharepoint? Thanks for sharing

[@jiejenn]

You will have to incorporate SharePoints API.

[@HappyLife-um2tn]

Thank you@@jiejenn

[@weiyang145]

The output files are corrupted. I can't open it

[@MrVenus18]

Can you please paste code here

[@AnubhavKashyapYt]

Give code sir

[@jiejenn]

Ok

[@AnubhavKashyapYt]

@@jiejenn I'm facing runtime error 9
Subscript out of range

[@larmondoflairallen4705]

@@AnubhavKashyapYt Same here. I've triple-checked the code and it still doesn't like that step

[@weiyang145]

​@@larmondoflairallen4705 U may try replace
As is : wb_source.Worksheets("Data").Copy
To be : wb_source.Worksheets("Sheet1").Copy