Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
convert Excel to "Text Only"
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 "Eric" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how i convert "100" to "hundred"( number to text) in excel-2007 | Excel Worksheet Functions | |||
How can I convert numbers (ex. "4") to text (ex. "four") | Excel Discussion (Misc queries) | |||
convert "15000" to "Fifteen thousand" in excel cell? | Excel Worksheet Functions | |||
can we convert "2 days 16 hrs" to " 64hrs" using excel functions | Excel Worksheet Functions | |||
Why does excel convert my text "6990011011234" to "6.99E+12"? | Excel Discussion (Misc queries) |