vb
Hi,I have 80 excel files with me. I have placed the files in Source folder. File names are like A1.xls, A2.Xls, A3.xls, B1.xls, and B2.xls .Now I have to convert these 80 excel files in to 20 tab delimiter files. The result should be tab delimiter format. All A.xls (A1.xls, A2.Xls, A3.xls) files should be one group (A.txt) . B.xls should be another group (B.txt). I have to save the result in Target folder as A.txt (All A1.xls, A2.Xls, A3.xls should be in this file), B.txt (B1.xls, and B2.xls should be in this file) how can I proceed to achieve this in simple manner? Please give me suggestions/code.
0