OP,

I don't see the original post, only this reply, so I'm replying to the reply.

You want what's called a "Fixed-width" file. Each field has a prescribed count of
characters. No delimiters (such as commas). Read "Space-delimited (prn)" and "Fixed-width"
at http://www.smokeylake.com/excel/textfiles.htm for two ways to accomplish this.

--
Earl Kiosterud
www.smokeylake.com

Note: Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...

-----------------------------------------------------------------------
" wrote in message
oups.com...
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/