Export multiple excels sheets into text files

[Rflores22]

Hi, 

I have a folder of excel workbooks with the same 4 columns, I would like to export the the same column from all the excel sheets into text their own separate text files. That is, so they keep the same file name except - only difference is they will be .txt files. I could modify and "save as" one by one but want to know if I could do this all at once. Do I have to write a macro for this? Appreciate any help, thanks!

Rodolfo

[#2]

Hi @Rflores22 

Please find below link might be helpful for you,  

https://excelexciting.com/how-to-save-excel-file-to-text-file-using-vba/

You can use this code to save your excel file as text, copy the code from the above link and paste it into your personal macro workbook. use the his code whenever you need it. If you need to loop this action then you can alter the code as per your need.

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official/Best Answer to help the other members find it more