Convert Multiple Excel files to single txt file

[JawaharPrem]

Hi All,

how to convert multiple excel .xlxs file to a single txt file, we are doning in multiple csv to one single txt through batch file, but iam unable to find any batch for excel to txt, it is possible.

Thanks
Jawahar Prem

 

[Marc L]

Hi !

As here it is the Excel formulas forum,
just save each Excel worksheet to a text file then use your batch file …
You can activate Macro recorder before operating manually
in order to obtain your own free code !
​

 

[JawaharPrem]

Hi Marc,

Thanks for your time..

we are already doing in that way , just asked to now is there is option to create batch for the same.


Thanks
Jawahar Prem

 

[Deepak]

You may do.

Merge multiple excel in one then convert it to txt.

Have a look here!

http://forum.chandoo.org/threads/merge-sheet1-from-multiple-workbook-using-single-connection.33746/