Forum Discussion
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 kee...
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