View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Eric Eric is offline
external usenet poster
 
Posts: 1,670
Default convert Excel to "Text Only"

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?