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?
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?