convert Excel to "Text Only"

[Guest]

I have an old program which will only accepts Excel files which have been
converted from Excel to Word 2000 and then formatted in Word 2000"Text Only"
format.

Is there a way write a Macro which will do the same thing in Excel?

I have tried using the "*.txt", "*.csv" in Excel. It doesn't work. I have
also tried using Word 2003 "Plain Text" and that doesn't work. I have to use
Word 2000 "text only" If I use Word 2003 the in line break with cr/lf
truncates the information too early.

Is there a macro I can create to do the same conversion and save format in
Word 2000?

 

[NickHK]

Eric,
From what I can tell about Word's Text Only format, is that it's a single
column of entries.
One way would be to traverse your .UsedRange by rows, writing each value &
vbnewline to a file.

NickHK