VishalkumarT
Technical User
Dear Friends
I have a Workbook and it contains 10 Worksheets.
(for example, c:\wb.xls)
So how can I store separate worksheets from this Workbook in a folder, with names like 1.xls, 2.xls ... 10.xls
(e.g. c:\ws\1.xls, c:\ws\2.xls ... c:\ws\10.xls)
And then I want to convert this worksheets as text files, I mean 1.txt, 2.txt ... 10.txt
(e.g. c:\ws\1.txt, c:\ws\2.txt ... c:\ws\10.txt)
Thanks for your replies in advance.
Regards
Vishalkumar
I have a Workbook and it contains 10 Worksheets.
(for example, c:\wb.xls)
So how can I store separate worksheets from this Workbook in a folder, with names like 1.xls, 2.xls ... 10.xls
(e.g. c:\ws\1.xls, c:\ws\2.xls ... c:\ws\10.xls)
And then I want to convert this worksheets as text files, I mean 1.txt, 2.txt ... 10.txt
(e.g. c:\ws\1.txt, c:\ws\2.txt ... c:\ws\10.txt)
Thanks for your replies in advance.
Regards
Vishalkumar