Creating & Exporting ASCII Fixed Length Records

[tmb]

I'm not sure you can do this in Excel but thought I would bounce off you
guys...

I want to create a data input form in Excel and then export it as an ASCII
Fixed Length Record.

Each field has a specified lenght of characters/bytes.

First I thought of doing it like this...

Name _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
Address _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
Account: _ _ _ _ _ _ _ _ _ _

But, when you highlight this and try to export, all the field will be the
same length... I think?

I could do it all on a single row maybe with titles over each cell and combo
boxes under each.

What do you guys think is the easyest way to do this? (Short of an Access
database

thanks for any help
\

 

[Beege]

tmb,

Try this link, do some experimentation...

http://www.excelforum.com/archive/index.php/t-230128.html


Beege

 

[Earl Kiosterud]

Tmb,

A way that seems to work is to use the "space delimited (prn)" file format.
It needs to be set up first. So you have to do some setup.
http://www.smokeylake.com/excel/textfiles.htm. Read "Space-delimited
(prn)."