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

preview_player
Показать описание
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!
-------------------------------------------------------------------------------------------
☕ Venmo: @Jie-Jenn

► Support my channel so I can continue making free contents
---------------------------------------------------------------------------------------------------------------

#excel #vba #excelvba
Рекомендации по теме
Комментарии
Автор

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 ?

rohitpatil
Автор

Works Perfectly!!!! Thank you so much!

adamamer
Автор

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.

AdAstraLeo
Автор

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

vasudevg
Автор

wb_target.saveas data_file_folder & replace (file name, ".xlsx", ".csv"), 6

exception has been thrown by the target of an invocation

Please help

sandipdas
Автор

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

jonelatendido
Автор

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

HappyLife-umtn
Автор

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

weiyang