On 19 Mag, 08:50, shaji wrote:
Hi,
I have to submit salary details to bank in txt format with following format.

1st field with 16 char length, 2nd field with 3 char, 3rd with 8 char, 4th
with 1 char, 5th with 17 char & 6th with 30 char.

All columns are to be left aligned except the 5th column which is to be
right aligned.

Sample data is given below:

A B C D
E F
0408040100002788 INR 0408 C 20878.00 Amrendra Pratap Singh
0408040100002798 INR 0408 C 26097.00 Bhan Prakash
0408040100002830 INR 0408 C 28470.00 Chandrakant Chandramouli
0408040100002832 INR 0408 C 36062.00 Gajanan Pranjpe
0408040100002833 INR 0408 C 9490.00 Hari Singh
0408040100002840 INR 0408 C 28944.00 Jitender Rana
0408040100002842 INR 0408 C 39843.00 K K Dutt

Can any one help me with a vb code toexportmy excel data to txt in the
prescribed format.

thanks

Try this one:

DataTime Documentation
http://cam70.sta.uniroma1.it/DataTimeDocumentation/

DataTime Universal (downloadable)
http://cam70.sta.uniroma1.it/DataTimeUniversal/