VBA to export Fixed Len ASCII from Excel ?

Does anybody have a VBA script that would get us started on exporting data
from Excel to a file?

We want to export it as Fixed Length ASCII

And put in a CRLF after certain cells to indicate 'end of record'

Thanks for any help.

tmb

Take a look at

http://www.mcgimpsey.com/excel/textf...tml#fixedfield

In article <[email protected]>,
"tmb" <[email protected]> wrote:

> Does anybody have a VBA script that would get us started on exporting data
> from Excel to a file?
>
> We want to export it as Fixed Length ASCII
>
> And put in a CRLF after certain cells to indicate 'end of record'
>
> Thanks for any help.
>
> tmb