Forum Discussion

Rflores22's avatar
Rflores22
Copper Contributor
Aug 24, 2020

Export multiple excels sheets into text files

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

1 Reply

  • ExcelExciting's avatar
    ExcelExciting
    MVP
    Aug 26, 2020

    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

Resources