PDA

View Full Version : Export Excel to .txt



magaupe
09-03-2008, 07:55 PM
Hi guys,

How can I export an Excel file to .txt following a pre-defined layout plus adding a space between the values of the columns?

Example

These are the columns:
NAME: 04 DIGITS
LOCATION: 03 DIGITS
FINAL LOCATION: 03 DIGITS
ZONE: 02 DIGITS
FINAL SUBZONE: 04 DIGITS
CODE: 02 DIGITS
"WHITE SPACE": 39 DIGITS

You guys have a macro for that?

shamsam1
09-03-2008, 10:15 PM
check this link

http://www.cpearson.com/excel/ImpText.aspx

shamsam1
09-03-2008, 10:17 PM
check the attachment

magaupe
09-03-2008, 11:17 PM
check the attachment

What exactly does it do?

Kenneth Hobs
09-04-2008, 07:31 AM
If you posted an example xls and txt file, it would help.

shamsam1
09-04-2008, 09:30 AM
cross posting with mrexcel.................

please avoide that