It just takes a few lines of VB code:

Sub export_text()
textstring = Range("B4").Value
Open "c:\data\description.txt" For Output As #1
Print #1, textstring
Close #1
End Sub

HTH,
Nikos

"lothario " wrote in message
...
How do I send the data in cell b4 to a plain text file
c:\data\description.txt

Cell b4 contains a function and the result is some lengthy text data

If the c:\data\description.txt file exists then it should be
overwritten.


---
Message posted from http://www.ExcelForum.com/